Forum Discussion

Stabben23's avatar
Stabben23
Helper I
6 years ago
Solved

Total sum in Matrix

Hi,   I need help to get correct total sum in my Matrix, this should be done in DAX. I have Pcs in carton from one table on article level, this works on all rows. I need some filter (I guess) to f...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi Stabben23 

This is a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
 
For your case, you could try this way:
measure =
VAR _table =
    SUMMARIZE (
        'Table',
        'Table'[Customer Group],
        'Table'[Articles],
        "_Cartons", [Cartons]
    )
RETURN
    SUMX ( _table, [_Cartons] )
 
Regards,
Lin
  • Stabben23's avatar
    Stabben23
    Helper I
    6 years ago

    v-lili6-msftthanks that you show me how to solve this kind of "measure total problem", very useful.

    This is a must know for every developer, thanks again!