Measure Totals in Data View: Force to be a sum

Scott
Scott Customer
Level 100: Foundations of Building in Board Name Dropper First Comment
in Platform

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

image.png

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.

Accepted Answer

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes
    Answer ✓

    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.

    image.png
    image.png

    Hope this helps.

    Thanks,

    Samson.

Answers

  • Scott
    Scott Customer
    Level 100: Foundations of Building in Board Name Dropper First Comment

    Many thanks Samson! This is really helpful and solved my issue.

Categories