Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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" }
)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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" }
)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks you so much used the first, ad now looking into the IN {
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |