How to SUM of a min Measure?

[_Melenios_]

Hi all,

I have a measure that compares two column tables and get the MIN value. My problem is that on the Grand Totals is still shows the MIN of these two columns and not the SUM as i would like.

That's the measure which creates a new table and compare the two columns :

Get_MIN:=VAR

NewTable=

UNION(

ROW("Value",[Column1]),

ROW("Value",[Column2])

)

RETURN

MAXX ( NewTable,[Value]))

Any suggestions?

[parry2k]

@_Melenios_ here is the measure, use this:

Sum of Minimum = SUMX ( SUMMARIZE ( Tables, Tables[var2], Tables[var3], "@Min",  MIN ([Cake],[CAP] ) ), [@Min] )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[v-deddai1-msft]

Hi @_Melenios_ ,

Would you please show us some sample data or sample pbix by onedrive for business? Then we can help you more correctly.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[_Melenios_]

Hi @v-deddai1-msft ,

I uploaded a link of my PBI.

As you can see the  problem here is that per individual row a get the min of these two measures but instead having the SUM on my table i still get the MIN of measures Totals.

Thanks in advance for any suggestion!

[v-deddai1-msft]

Hi @_Melenios_ ,

Please try the following measure:

Min_OF_CapCaKE1 = SUMX(Tables,MIN(Tables[var2],Tables[var3]))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[parry2k]

@_Melenios_ you never clarified are you taking min from columns or measures. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[parry2k]

@_Melenios_ there are many ways to sort this, one is to create a calculated column with the following expression and then use this new column in your visual and show the sum

Min value = MIN ( Table[Column1], Table[Column2] )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[_Melenios_]

Hi @parry2k ,

Thanks for your reply. Unfortunatelly this solution won't work for me since i use already two measures for this comparison and by getting a calculated column  it would be far more source consuming and heavier.

Any other suggestion/recomendation avoid having a calulated column? 

Cheers!