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


     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

According to your description, you want to get the max/min among multiple columns. Right?

 

In this scenario, we need to unpivot the Column B, C,..., F, have them group on Column A. Then calculate the min value within Column A group. Now you can summarize Column A and the calculation into a new table and build the relationship with source table. Please refer to steps below:

 

1. Click on Column A, select "Unpivot Other Columns"

2. Then filter the empty rows.

3. Create the Min Value measure:

Min Value = CALCULATE(MIN('Table5 (2)'[Value]),ALLEXCEPT('Table5 (2)','Table5 (2)'[Column A]))

4. Create a calculated table:

Table 2 = SUMMARIZE('Table5 (2)','Table5 (2)'[Column A],"Min Value",[Min Value])

5. Build the relationship with source table source table.