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 two survey types - people leader and Trainer Survey - each fill out different attributes and rate them on a scale from (poor, fair, good, very good, and excellent). Id like a visual to display each together, but my % of row total is adding up everything vs. seperating by the survey type. I've attached visual below of what im trying to do (essentially each row should total 200%, 100% sum for each of the survey types). BI file attached as well - see the recruiting -onboarding tab
https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf?e=56kx5j
Solved! Go to Solution.
Hi, @jcastr02
Based on my research, you may try to use the following measure.
Result =
DIVIDE (
CALCULATE ( COUNT ( 'Append1'[Response] ) ),
CALCULATE (
COUNT ( 'Append1'[Response] ),
FILTER (
ALLSELECTED ( 'Append1' ),
'Append1'[Attribute] IN FILTERS ( 'Append1'[Attribute] )
&& 'Append1'[Survey Type] IN FILTERS ( 'Append1'[Survey Type] )
)
)
)
Finally you could go to 'Modeling' ribbon, modify the format to percentage.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jcastr02
Based on my research, you may try to use the following measure.
Result =
DIVIDE (
CALCULATE ( COUNT ( 'Append1'[Response] ) ),
CALCULATE (
COUNT ( 'Append1'[Response] ),
FILTER (
ALLSELECTED ( 'Append1' ),
'Append1'[Attribute] IN FILTERS ( 'Append1'[Attribute] )
&& 'Append1'[Survey Type] IN FILTERS ( 'Append1'[Survey Type] )
)
)
)
Finally you could go to 'Modeling' ribbon, modify the format to percentage.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |