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..