Measure showing incorrect total

[mr_reygan]

Hi,

I have a measure which calculates cost based on parameters. At the row level, the cost is correct. But the totals show incorrect results.

The expected results are:

Drinks - 13

Fruit - 5

TOTAL - 18

Can someone help correct my calculation please?

[v-robertq-msft]

Hi, @mr_reygan 

According to your description, you want to get the correct total in the total row, you can try my steps:

1. Create a measure:

Cost_new =

var _new=SUMMARIZE('Table','Table'[Category],"_value",[Cost])

return IF(HASONEVALUE('Table'[Category]),[Cost],SUMX(_new,[_value]))

2. Go to the Matrix, replace the [Cost] with the new measure [Cost_new], like this:

And you can get what you want.

You can create a new measure for every measure which has a wrong total value in Matrix using this method and replace them in the chart.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mr_reygan , Try like

sumx(Summarize(Table, Table[category], "_1",[Cost]),[_1])

[mr_reygan]

@amitchandak , great! it worked! 🙂

Do I always have to create 2 measures? 1 for row level and another 1 for totals?

[mahoneypat · Accepted solution]

Please try this expression that references your existing Cost measure.  Replace Table with your actual table name.

Cost SUMX = SUMX(VALUES(Table[Category]), [Cost])

Regards,

Pat