Obtención del máximo de medidas calculadas múltiples

[User5231]

¿Hay alguna manera de tomar el máximo de múltiples expresiones calculadas? Quiero la suma de la línea 3 superior más el máximo de la siguiente 4. ¿Es posible?

1 Rendimiento Real - CALCULATE(Promedio(Pedidos[Días Reales Abiertos]), 'Piezas Maestras'[Descripción] - "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 , no debería crear un rango usando

'Master Parts'[Description] y average(Orders[Actual Days Open]) y luego utilíctelo para filtrar

Para el rango Refiera estos 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]

Usé esto y funcionó

Rendimiento de CTF Real ?

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")

devolución

CTF + MAXX(CTFSubs,[Valor])