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 incorre...
Need Help
  • 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))
StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
4 years ago

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