Forum Discussion

Helper I

4 years ago

Solved

Total sum with different granularity

Hi, I want to Summerize a total value for Goal. Goal is a one time value on my machines. The model is connected With Machine (Maskin) field to Transaction table, no other table is connected. Value,...

Need Help

Greg_Deckler
4 years ago
Stabben23 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

4 years ago

Stabben23 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

Stabben23

Helper I

4 years ago

Hi Greg_Deckler

I got it to work with a measure from Measure Totals, The Final Word, I now have to get the head around this syntax, thanks!

Forum Discussion

Total sum with different granularity

Related content

Data Granularity

Handle AverageX on different granularities matrix drilldown

Visual with different granularity how to switch?

Average granularity

Calculate between different granularities