Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calculate the percentage of each reponse for Q1 by year. For example, the number of people who responded 5-Strongly Agree in 2015, 2016, etc.
I am using a clustered column chart as my visual with Survey Year as the legend, Q1 as my axis, and I created a new measure for the value:
o
Solved! Go to Solution.
Hi @Anonymous
COUNT( ) already ignores blanks and as for "NA - Not Applicable", you can add a filter condition to your CALCULATE:
Satisfaction_Survey[Q1] <> "NA - Not Applicable"
or else you could use a slicer with [Q1] to deselect "NA - Not Applicable"
Hi @Anonymous
COUNT( ) already ignores blanks and as for "NA - Not Applicable", you can add a filter condition to your CALCULATE:
Satisfaction_Survey[Q1] <> "NA - Not Applicable"
or else you could use a slicer with [Q1] to deselect "NA - Not Applicable"
Thank you. When I try to add the slicer for Q1, it just adds/subtracts from the x-axis since I have Q1 response options for this axis. I cannot use my measure as a slicer even though this is what I want to filter.
When I add a filter to CALCULATE, I am getting an error because I don't know how to do this properly. My error is that <> is incorrect. Also, BLANK is listed in the data as an actual response and not blank/null. It is treated the same as NA - Not Applicable.
@Anonymous
You need the full version of what I wrote, not just half of it:
Satisfaction_Survey[Q1] <> "NA - Not Applicable"
Also, what is the ALLEXCEPT( ) for?
AllExcept is to filter by year.
Sorry. I am very new to this, and I don't usually write code.
@Anonymous
Hmmm... I'm not sure you understand how to use ALLEXCEPT correctly. Can you paste the data in your image above in text format here? So that it can be readily copied to run a couple of tests. It's always better to do include data that can be copied or the pbix file itself. It makes things much easier for people trying to help. You can copy a part of your table and paste it in your post.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |