Forum Discussion

mr_reygan's avatar
mr_reygan
Frequent Visitor
5 years ago
Solved

Measure showing incorrect total

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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

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]))
  1. 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.