Forum Discussion

Helper I

5 years ago

Solved

Problems with Total in matrix with measures

I've created a simple matrix and added to them a measure (with switch inside): Money = SWITCH(TRUE(), AND(Sale[Sales]>=6000,Sale[Sales]<7500),100, AND(Sale[Sales]>=7500,Sale[Sales]<9000),300, ...

Need Help

Tips and Tricks

Tutorial Requests

Greg_Deckler
5 years ago
Daniel_Fdrvc This looks like a measure totals problem. Very common. See my post about it here: 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

Greg_Deckler

Community Champion

5 years ago

Daniel_Fdrvc This looks like a measure totals problem. Very common. See my post about it here: 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

Daniel_Fdrvc

Helper I

5 years ago

Yes yes yes 🙂 thank you, in second link i've found what i was looking for!

Forum Discussion

Problems with Total in matrix with measures

Related content

Matrix Visual Hierarchy Level Problem

Measure formula problem

It's a matrix totalling problem!

Matrix Header Heigth Problem only online

Dax measure for below problem