Forum Discussion
Distinct Count calculated wrong
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! 🙂
- Anonymous4 years ago
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))
2 Replies
- AnonymousNot applicable
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)) - StefanoGrimaldi
Resident Rockstar
check the raw data itself and do the calculation manually cause that way you did it should wr=ork fine for what you asking