Getting the Max of Multiple Calculated Measures

[User5231]

Is there a way to take the max of multiple calculcated expressions? I want the sum of the top 3 line plus the max of the next 4. Is this possible?

1 Throughput Actual = CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "CTF") +

2 CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "CTF TH") +

3 CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Ebar & Paint") +

4 Max(CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Front Support"),

5 CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Saddle"),

6 CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Sides"),

7 CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Ebar"),

8 CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Case")))

[amitchandak]

@User5231 , I thin you should create a rank using

'Master Parts'[Description] and average(Orders[Actual Days Open]) and then use that for filtering

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[User5231 · Accepted solution]

I used this and it worked

CTF Throughput Actual =

VAR CTFSubs =

UNION(

    ROW("Value",CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Front Support")),

    ROW("Value",CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Saddle")),

    ROW("Value",CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Sides")),

    ROW("Value",CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Ebar")),

    ROW("Value",CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Case")),

    ROW("Value",CALCULATE(average(Orders[Actual Days Open]), 'Master Parts'[Description] = "Tube"))

)

VAR CTF =

    Calculate(average(Orders[Actual Days Open]),'Master Parts'[Description] = "CTF TH") +

    Calculate(average(Orders[Actual Days Open]),'Master Parts'[Description] = "CTF") +

    Calculate(average(Orders[Actual Days Open]),'Master Parts'[Description] = "Ebar & Frame")

RETURN

CTF + MAXX(CTFSubs,[Value])