Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Da...
Need Help
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    4 years ago

    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" }
        )
)
MFelix's avatar
MFelix
Super User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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