Forum Discussion

srkase's avatar
srkase
Helper IV
6 years ago
Solved

MULTIPLE MEASURE MAX

Hi ,   I am new to Power BI .   I have created few measures like this.   TCr1516 = CALCULATE(SUM('PROD_CABLE'[TOTAL CR])+0,PROD_CABLE[YEAR]="20152016") // to calculate total of year 20152016 ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi srkase 

     

    Try this 

    Measure = 
VAR __list = { [TCr1516], [TCr1617], [TCr1718], [TCr1819], [TCr1920] }
RETURN 
MAXX( __list, [Value] )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi srkase 

 

Try this 

Measure = 
VAR __list = { [TCr1516], [TCr1617], [TCr1718], [TCr1819], [TCr1920] }
RETURN 
MAXX( __list, [Value] )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn


 

Ro_'s avatar
Ro_
Regular Visitor
3 years ago

Hello, 
Thanks for this it is very useful!

Is there a way to edit this DAX to return the Name of the measure that returned the lowest value as oppose to the value its self?

Thanks,
Ross