Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all! I am having an issue and can't wrap my head around the solution or problem after hours of googling. I would really appreciate any help or ideas.
The problem: I am working on analyzing a survey from 5 organizations that each coded responses differently. I appended them in PowerQuery and then cleaned them in PQ and Dax. There are 703 unique respondents to the survey who were asked about using different water sources. However, when I create a bar chart, it shows more than 703 yes/no responses.
The visual is based off this, with count distinct for the Index:
The data in the table is based off a calculated column in Dax:
The columns "uses for Cooking" and "Uses for Drinking" I made using Switch as per below (example from "Uses for Drinking")
I think the problem with the table might be because it is showing a distinct count of indexes for both the "yes" and "no" responses per water source per type of use ( I want the distinct count of indexes for "yes" OR "no", so that it will show something like "Count distinct Index if "yes" or "no" for any type of use of the water source"
Is there a problem with my calculated columns?
Is there a way I can create a measure to get this distinct count?
Or any other ideas about what the problem could be and how to solve it?
Thanks so much in advance to all.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |