topic Re: Display Values without including in calculation in DAX Commands and Tips

Display Values without including in calculation

Gsar — Wed, 23 Mar 2022 17:03:41 GMT

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

Re: Display Values without including in calculation

tamerj1 — Wed, 23 Mar 2022 17:48:26 GMT

Hi Gsar

try

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

Re: Display Values without including in calculation

v-yalanwu-msft — Mon, 28 Mar 2022 03:16:21 GMT

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.