Counting selected filter

[Anonymous]

Hi there, 

Am trying to do something like below to show the number of filter selected but no luck yet. Pls help !

FilterCount = IF(ISFILTERED(FourandFive[Adm Year])<5,"Multiple Filter",IF(ISFILTERED(FourandFive[Adm Year])>5,"All Filter"))

[RitzCracker · Accepted solution]

Hi,

Here is how I managed to solve this :

Region Selected = IF(COUNTROWS(FILTERS ( Region[RegionName]))>8, "All Regions",
CONCATENATEX(
ALLSELECTED(Region[RegionName]),
Region[RegionName],
"," & " "
))

In this sample if the number of regions selected are more than 8, it shows ALL REGIONS, otherwise it will show a list of selected Regions separated by commas.  I used this on the header of my report.

I hope this helps!

Ross R

[Anonymous]

Thank you Ross that helps a lot, I was able to modify the code to suite mine reqment.

Regards

Yomi