Count(distinct) and Legend in a visual help

[Anonymous]

Hi, i was using count distinct for a visual and it was working well

I got 99 results

DISTINCTCOUNT(row1)

BUT 

If i add a legend to the visual, now i got 100 results

Because the legend =>    in "row2" makes some values in the visual different

How can i continue using the DISTINCTCOUNT in row 1 and continue having the same result?

(and keep the legend in the visual)

Thanks

[v-lili6-msft]

HI, @Anonymous 

This sounds like a measure totals problem.

See this post about it here:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

For example:

PK	Type	legend
1	A	L1
1	A	L2
2	B	L3
2	B	L3
2	C	L3

When there is no legend,

pk=1, distinct(type) is 1(A)

pk=2, distinct(type) is 2(BC)

Now, drag legend into it.

pk=1 has two value,distinct(type) is 1 (L1) and distinct(type) is 1(L2)

pk=2, distinct(type) is 2(L3)

So, what is your expected output if legend in the visual.

Best Regards,

Lin