Forum Discussion

rolf1994's avatar
rolf1994
Helper II
9 years ago
Solved

Only show data when count is over 50

Hi,   Would it be possible to do the following:   - Only show data when count is over 50.   We want to apply this because of privacy reasons.
Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

     

    as for COUNTDISTINCT I often have my problem with that in that I need to create an additional table

     

    Like you can solve it by doing this

    Modeling - New Table:

    DistinctCountTable = SUMMARIZE(UserData;UserData[Category];"TestDistinct";DISTINCTCOUNT(UserData[UserId]))

     

    create Relation Category to Category

     

    then

    when you click Apply its filtered correctly

     

    no idea how this can be done more beautifully I always end up creating new table in these cases

rolf1994's avatar
rolf1994
Helper II
9 years ago

Thanks, this was already really helpfull.

 

What I want to do is not pre filter data for categories that contain a distinctcount lower than 4 but I only want my report to show data if total DistinctCount of UserId is greater than 4. So if DistinctCount for UserId for Category A, B, C and D is 20 I want to see all categories. If DistinctCount of Category 'B' is 3 and someone filters on Category 'B' I want the report display no data.

 

Would that be possible?

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

just create an additional SUM measure:

when I select B data disappears