Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! 🙂
Solved! Go to Solution.
The problem was fixed with creating a measure to filter the data instead of using the filter-panel.
So the measure was:
check the raw data itself and do the calculation manually cause that way you did it should wr=ork fine for what you asking
Proud to be a Super User!
The problem was fixed with creating a measure to filter the data instead of using the filter-panel.
So the measure was:
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |