Distinct Count calculated wrong

[Anonymous]

Hi,

I want to make a KPI counting the Participants in a survey. When I have the participants in a table it shows correctly, but once I transform these into a count or distinct count it shows incorrectly.

You can see below what I mean:

Don't summarize:

Distinct Count:

I want to make a card showing the KPI of 1 instead of 5 - because you can see there's only one participant when I 'Don't Summarize'.

I have tried all three posibilities in terms of joins from the two tables (Both, table1 filters table 2 and table 2 filters table 1).

I hope someone can help.

Thank you! 🙂

[StefanoGrimaldi]

check the raw data itself and do the calculation manually cause that way you did it should wr=ork fine for what you asking 

[Anonymous · Accepted solution]

The problem was fixed with creating a measure to filter the data instead of using the filter-panel.
So the measure was:

Filter =

CALCULATE(DISTINCTCOUNT('5GENAVGPARTICIPANTVIEW'[PARTICIPANTID]),FILTER(V_BENCHMARK, [PBISlicer Check] = 1))