Display count of records only if a selection has been applied in any of the filters

[zjdoonj]

Hi Friends,

I have a KPI below which is displaying "Records Returned" and expression I used is  following:

Count(distinct[Project Code])

My requirement is to display " Records Returned " only if there is any or multiple selections in several filters been applied otherwise KPI should display zero. Filters on the app are "Country cd" , "State cd", "City Cd", "Region Cd" , "Assigned Officer"   etc.  and may be few more going forward.

How can we achieve that?

Thanks,

ZJ

[AshutoshBhumkar]

Great 🙂