Hello everyone,
I have the following measure in Live connection in Power BI desktop:
Variation =
VAR Code_T = 1600
VAR Code_T_1 = 1500
VAR SUM_T = CALCULATE([Measure1];Table[Code_Column] = Code_T)
VAR SUM_T_1= CALCULATE([Measure2];Table[Code_Column] = Code_T_1)
return SUM_T - SUM_T_1
Code_T and Code_T-1 are the max and second max respectively of Code_Column, for each of these I calculate the [Measure1] and [Measure2] that already exists in the model.
If I hardcode the values 1600 and 1500 this works really well.
But instead of hardcoding the values I would like them to be dynamic so I would like to put the max value of Code_Column in Code_T, instead of 1600, and put the second max value of Code_Column in Code_T_1, instead of 1500.
I tried the following but with no success:
Variation =
VAR Code_T = MAX(Code_Column)
VAR Code_T_1 = CALCULATE(MAX(Table[Code_Column]);Table[Code_Column] < Code_T)
VAR SUM_T = CALCULATE([Measure1];Table[Code_Column] = Code_T)
VAR SUM_T_1= CALCULATE([Measure2];Table[Code_Column] = Code_T_1)
return SUM_T - SUM_T_1
Any ideas? I'm kind of new to DAX.
Thank you.
