Forum Discussion
Dax Formula simplification
Hi All,
sorry if in the wrong topic area, but wondering if someone could help?
looking to simplify the following "working" measure
Eliminations = -
(CALCULATE([Actuals INDY],'Finance Data','Finance Data'[ANAL_T5]="II")+CALCULATE([Actuals INDY],'Finance Data','Finance Data'[ANAL_T5]="IRL")+CALCULATE([Actuals INDY],'Finance Data','Finance Data'[ANAL_T5]="IML")+
CALCULATE([Actuals MRL],'Finance Data','Finance Data'[ANAL_T5]="II")+CALCULATE([Actuals MRL],'Finance Data','Finance Data'[ANAL_T5]="IRL")+CALCULATE([Actuals MRL],'Finance Data','Finance Data'[ANAL_T5]="IML")+
CALCULATE([Actuals MRU],'Finance Data','Finance Data'[ANAL_T5]="II")+CALCULATE([Actuals MRU],'Finance Data','Finance Data'[ANAL_T5]="IRL")+CALCULATE([Actuals MRU],'Finance Data','Finance Data'[ANAL_T5]="IML")+
CALCULATE([Actuals MTC],'Finance Data','Finance Data'[ANAL_T5]="II")+CALCULATE([Actuals MTC],'Finance Data','Finance Data'[ANAL_T5]="IRL")+CALCULATE([Actuals MTC],'Finance Data','Finance Data'[ANAL_T5]="IML"))
it does work as intended but seems to not be the best way to do it,
have tried looking on how to implement is or into the formula but coulnd see anything on search that fit the example
Hi Anonymous ,
Try one of the following formulas:
Eliminations = - CALCULATE ( [Actuals INDY] + [Actuals MRL] + [Actuals MRU] + [Actuals MTC], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) Eliminations = - ( CALCULATE ( [Actuals INDY], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) + CALCULATE ( [Actuals MRL], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) + CALCULATE ( [Actuals MRU], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) + CALCULATE ( [Actuals MTC], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) )
2 Replies
Hi Anonymous ,
Try one of the following formulas:
Eliminations = - CALCULATE ( [Actuals INDY] + [Actuals MRL] + [Actuals MRU] + [Actuals MTC], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) Eliminations = - ( CALCULATE ( [Actuals INDY], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) + CALCULATE ( [Actuals MRL], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) + CALCULATE ( [Actuals MRU], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) + CALCULATE ( [Actuals MTC], 'Finance Data', 'Finance Data'[ANAL_T5] IN { "II", "IRL", "IML" } ) )