Forum Discussion
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.
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
Create a Measure that does the specific count you need
Put it in Filter with > 50