Display Values without including in calculation

[Gsar]

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

[v-yalanwu-msft · Accepted solution]

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.

[tamerj1]

Hi @Gsar 

try

IF ( HASEONEVALUE ( Table[Group] ), SUM ( Table[Value] ), CALCULATE ( SUM ( Table[Value] ), Table[Group] = 2 ))