Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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! 🙂

 

  • Anonymous's avatar
    Anonymous
    4 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

  • Anonymous's avatar
    Anonymous
    Not 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))
  • check the raw data itself and do the calculation manually cause that way you did it should wr=ork fine for what you asking