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

v-lid-msft thank you for your reply!

 

28 is indeed the frequency I was talking about. But how can I hide or empty the cell "Persoonlijk welzijn x s3=1" if the frequency would be below 7? 

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

Hi Anonymous ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,