When I format my measure to % and compare my chart to a matrix, the numbers in the chart are lower because in the matrix, I filter out BLANK and NA - Not Applicable responses. for the Percent of Column Total.
How do I filter out BLANK and NA - Not Applicable responses in my measure so anyone who responsed with these are not calculated in the percentage/total?
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.
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.