Forum Discussion
Counting selected filter
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"))
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
2 Replies
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