Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
87 | |
84 | |
70 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |