Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

Matrix visual with 2 split columns

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 

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    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.