Forum Discussion
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, date, machine field is from Transaction table, Goal from my Goal table.
The sum in this case should be 520.8 instead of 130.20.
I want this as a Dax measure.
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
2 Replies
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/547907Hi 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!
