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


 

  • srkase's avatar
    srkase
    Helper IV
    6 years ago

    am getting an error message boss

     

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi srkase 

       

      Most likely it's your measure where you compare PROD_CABLE[YEAR]="20152016".

      is PROD_CABLE[YEAR] formatted as text or number?

       

      Best Regards,
      Mariusz

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

      Please feel free to connect with me.
      LinkedIn

       

      • srkase's avatar
        srkase
        Helper IV
        6 years ago

        previously it is as wholenumber and now changed it as text.. it works now..

         

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    As what Ro_  mentioned, is there a way to return the name of the measure instead of the value?

  • GRN_VPR8's avatar
    GRN_VPR8
    Frequent Visitor
    2 years ago


    is there a way to return the name of the var i.e

    [TCr1920]