total sum not working for distinctcount measure

[Anonymous]

Hi, I have this table :

"PROMOTORES_DISTINCT" is a measure = DISTINCTCOUNT(NPS_DATABASE[Id])  . Why I´m getting  287 as total? It should be 319!!!

What I need is the total distinct count of people (Id) for each category from Score_p1 column....What am I doing wrong ?

[Anonymous]

Thanks a lot @Jihwan_Kim  !!!!!!! that was very helpful!

[Jihwan_Kim]

Hi,

I am not sure how your table looks like, but I think some people are in the one-score-group, and also in the other-score-group at the same time.

Or, please share your sample pbix file's link here, and then I can try to look into it to come up with a solution.

Thanks.

[Anonymous]

Hi @Jihwan_Kim , thanks for the answer. this is the link :

https://1drv.ms/u/s!AoOm48iQH2AihFFr5GrBYVkEHNch?e=r8ZO5n

[Jihwan_Kim · Accepted solution]

Hi,

Thank you very much for sharing.

In the [ID] column, when you filter it to see only june 2022 information (because the page was filtered like this)

- ID = 2, there are three rows, and all of them shows different email address -> I am not sure if this is correct. And, two of them are under Promotor and one of them is under Detractor.

-ID = 5,  there are three rows, and all of them shows different email address -> I am not sure if this is correct. And, two of them are under Promotor and one of them is under Pasivo.

I am not sure what do you want to count, but if you just want to show the number 319, please try the below measure.

PROMOTORES_DISTINCT v2 =
SUMX (
    VALUES ( NPS_DATABASE[Score_P1] ),
    CALCULATE ( DISTINCTCOUNT ( NPS_DATABASE[Id] ) )
)