Forum Discussion

Gsar's avatar
Gsar
Frequent Visitor
4 years ago
Solved

Display Values without including in calculation

Hey Dax experts,   I have a question for you that I could not find the answer to.    Lets say that I have the following data Value Group 2 1 3 1 2 1 4 1 5 2 5 2 1 ...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Gsar ;

    Has Tamerj1 solved your problem? His method is correct, of course you also use the ISINSCOPE function, as follows:

    Measure = IF(ISINSCOPE('Table'[Group]),MAX([Value]),CALCULATE(SUM([Value]),'Table'[Group]=2))

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Gsar ;

Has Tamerj1 solved your problem? His method is correct, of course you also use the ISINSCOPE function, as follows:

Measure = IF(ISINSCOPE('Table'[Group]),MAX([Value]),CALCULATE(SUM([Value]),'Table'[Group]=2))

The final output is shown below:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.