Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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(ISF...
Need Help
  • RitzCracker's avatar
    RitzCracker
    8 years ago

    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

RitzCracker's avatar
RitzCracker
Advocate II
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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

 

Regards

Yomi