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,

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry for my late reply.

 

Your solution seems to work when you do it, the images you posted are indeed what I'm trying to achieve. I edited this reply because at first I got error messages using your formula. But I got that to work now.

 

Only problem is that the entire matrix goes blank now. And I can't make it appear again using this measure, so something is not right. Why does it work when you do it? Can you send me the file you did this in?

 

Best regards,

Jade

 

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! 🙂