Measure Totals in Data View: Force to be a sum

Scott

Hello Community, I am running an issue with the total value in a data view and wondering if there is an easy way to solve it. I have an example below

I want to calculate the $ impact on price difference (column K). For individual row the calculation is correct, not saying the total is wrong but I just want to force the total to be a sum of K3:K6. I had the similar issue before in Powerbi but I managed to solve it by using the DAX formula Hasonefilter like if(hasonefilter(Product Name),(D-I)*B,sumx((D-I)*B)

Just wondering if Board has similar formula that I can use in the data view or there is a way to make it happen?

Sorry I am new to Board and much appreciated for your help.

Samson Sunny

Hi Scott,

To view the sum of all the cells in the total change the summary property from 'Calculated' to 'Total' for the column K algorithm block in the data view layout.

Hope this helps.

Thanks,

Samson.