page level filters

[rmarountas]

Hi...I have a relatively simple-sounding question.  In order to protect confidentiality, I need to filter the number of cases that gets shown on one of my dashboards so that nothing shows in any of the visuals that is based on fewer than 20 cases. I know I can't use a calculated field to do this, but I can't seem to get other fields to work without excluding all cases.  

Any help greatly appreciated!  

[v-huizhn-msft]

Hi @rmarountas,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia

[v-huizhn-msft · Accepted solution]

Hi @rmarountas,

From what I know, you can use a calculated column using the formula below, then use it in page level filter. 

NewColumn=IF(Table[case]<=20,1,0)

Then in page level filter, select [NewColumn]=1, which will affect your report.

Best Regards,
Angelia

[rmarountas]

Hi and thanks for your reply.  Unfortunately I am still unable to get it to work.  I think the reason that the IF statement you included doesn't solve the issue is that I need to filter on the count of cases and not the value of cases.  For example, if I have 7 fatalities in zip code 443XX, filtering out cases with the IF statement you suggest counts each individual case as one, which is less than 20.  So the filter excludes all of them because each one of them has a count of less than 20.  However, if I have a zip code in the same table with more than 20 cases, the same thing happens.  It excludes all the cases because each one is less than 20.  I need some way of saying that if a table contains any zip code where the count of cases less than 20, don't display it, and if it contains 20 cases or more, display it on the table.