Forum Discussion

srkase's avatar
srkase
Icon for Helper IV rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper IV rankHelper IV
    6 years ago

    am getting an error message boss

     

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity 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
        Icon for Helper IV rankHelper 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]