DISTINCTCOUNT in table is working but in chart NO

[Anonymous]

Hi,

I`m using a measure to calculete de DISTINCT ID I have in a dataset. It works for tables, but not int charts. 

#UMD = CALCULATE(DISTINCTCOUNT('Depositos_cliente'[player_id]))

Te same measure in a table sums 1, but the same measure en in chart sums 2 🤔

Can anyone help find what I'm doing worng?

[FreemanZ]

hi @Anonymous 

@it could be that the same id presents in both categories. In table visual, 1 results from filter context, 2023-1 But in stacked bar chart, 2 is the simple sum of two 1s.

[Anonymous]

It is the same ID. That is my point. The total should always be 1.

The table count this ID as 1 although it is present in both categories, but the stacked bar chart shows a total of 2.

How can I fix this?