Sum a Min Measure

[Robfen1]

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!

[Greg_Deckler]

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

[Robfen1]

Thanks Greg and for the fast reply - I will look at those this afternoon!

[Robfen1]

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!

[AlexAlberga727 · Accepted solution]

Have you thought about creating a calculated column to identify the MIN value for each record. Then create a measure to SUM this column?