Forum Discussion
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 | 2 |
| 1 | 2 |
I want to achieve the following:
I want to include in my visualisation all the data, for both group 1 and 2, but I want only to include in my calculations only for value only the data that are in group 2.
So my end result when I would put it in a visual in power bi could look like that:
I can use calculate to exclude the data in group 1 but this will also prevent them from showing them in the visual.
Please let me know if my query makes sense.
Best,
Giorgio
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.
2 Replies
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.
