Dax Formula simplification

[Anonymous]

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 

[MFelix · Accepted 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" }
        )
)

[Anonymous]

Thanks you so much used the first, ad now looking into the IN {