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


     

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