Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix: add frequency and hide when frequency <7

I made a matrix to show the mean score per item (EA-PI column) for each of the genders (male, female, other).  I am now looking for a way to show the frequency of the genders as well. So for e...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can try to create a measure as value field of matrix to meet your requirement:

     

    Measure = If([IsValidGroup] = 1, Average('Table'[Value]), BLANK())

     

    (s3=7 was hidden when frequence reduce)


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Have you tried to change the [IS Valid Group] measure to following one we shared before?

 

IS Valid Group = 
IF ( DISTINCTCOUNT ( OrigineleData[Respondent] ) > 7,1, 2 )

 

Please also change the background color of measure, because replace the value, condition format will reset and I remember the text color of your matrix is white.


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It's working! It was the white background indeed... I didn't realize that the conditional formatting would disappear. 

I didn't even have to change the measure.

 

Thank you so much! 🙂