Forum Discussion
Sum a Min Measure
Hi all -
I have created a Measure and called in base pay : Base Pay:=1000
I then calculated another Measure from a table column called Weekly Pay:=Table[column]/52
Then created another measure to determine the Min of the above two, however when I use this measure in my report I get the Min result in the row (which is what I want), however I don't get the column to sum for the subtotal portion of the matrix.
Ideas??
Thank you!
Have you thought about creating a calculated column to identify the MIN value for each record. Then create a measure to SUM this column?
4 Replies
- Greg_Deckler
Community Champion
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/547907Thanks Greg and for the fast reply - I will look at those this afternoon!
I am having trouble because there are two measures involved i think -
...in the false argument of the hasonefilter function i feel like i have to go all the way back to the table column root to get the proper aggregation...not sure if that makes any sense??
Lmk - can alwyas add more info.
Thanks!
