Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 {
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |