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 ,

 

When use Allselected function, all the cells will return same result, Could you please try the following measure? 

 

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

 

If it doesn't meet your requirement, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to OneDrive For Business and share the link here.

Please don't contain any Confidential Information or Real data in your reply.


Best regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for your reply v-lid-msft, unfortunately your formula doesn't seem to work either. I uploaded my report on one drive for business here.

     

    All data in this report are fake. The matrix I was referring to is on page "Details gender".

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

      Hi Anonymous ,

       

      Based on my research with sample model you have shared, we find the each row (items column) has the same Unique Response ID from 0 to 186, so the distinct count for each cells in matrix are large than 7, we think it is the reason why measure does not work.

       

      For example, when items = "Persoonlijk Welzijn" and S3 = 1, the will be 28 distinct value in the “Respondant" column of origin table, does the 28 means the desire frequency?

       


      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?