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 displa...
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.

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.

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

This worked v-alq-msft Thank you!