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 have a table with two columns, one column has various questions, the other has responses that fall into 3 categories: positive, negative and neutral. I have a clustered column chart with the 'Questions' being the value for the Axis, the 'Categorized Responses' being the Legend, and then the Count of Categorized Responses being a value. This gives me a visual where I can compare the number of positive, negative and neutral responses were received for each question. I'm struggling to create a measure showing the percentage of positive, negative and neutral responses broken out by question.
Solved! Go to Solution.
What you essentially need is a measure that counts number of Positive responses, Neutral, and Negative. Then a separate measure that counts all rows. Lastly you'd have a measure that gets your percentage. When you wish to display this information, you can use the 3 percent measures and the context of the question should contrain the results
These measures need to be done using ALLEXCEPT such that is can take the context of which question it is considering. So i'd be expecting something like:
AllCount = CALCULATE( countrows('YourTable'), ALLEXCEPT('YourTable', 'YourTable'[Question]) ) PositiveCount = CALCULATE( countrows('YourTable'), ALLEXCEPT('YourTable', 'YourTable'[Question]), 'YourTable'[Answer] = "Positive" ) PositivePercent = DIVIDE( [PositiveCount], [AllCount] )
What you essentially need is a measure that counts number of Positive responses, Neutral, and Negative. Then a separate measure that counts all rows. Lastly you'd have a measure that gets your percentage. When you wish to display this information, you can use the 3 percent measures and the context of the question should contrain the results
These measures need to be done using ALLEXCEPT such that is can take the context of which question it is considering. So i'd be expecting something like:
AllCount = CALCULATE( countrows('YourTable'), ALLEXCEPT('YourTable', 'YourTable'[Question]) ) PositiveCount = CALCULATE( countrows('YourTable'), ALLEXCEPT('YourTable', 'YourTable'[Question]), 'YourTable'[Answer] = "Positive" ) PositivePercent = DIVIDE( [PositiveCount], [AllCount] )
Worked like a charm, thanks for your help again!
Okay I'll try that, thanks for the help.
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |