Forum Discussion
User5231
Helper II
Helper IIGetting the Max of Multiple Calculated Measures
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[...
- I used this and it workedCTF 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")RETURNCTF + MAXX(CTFSubs,[Value])
amitchandak
Super User
Super UserUser5231 , 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
User5231Helper II
Helper III 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])