Forum Discussion

ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago
Solved

Dynamic Titles when mutiple values selected

Hi Team,   I have a requirement to show the selected filter values in the title. For example : i have country column as filter. If we select "India" then my title should show as "Selected Country:...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago
    Measure = 
VAR __allCount = COUNTX(ALL(Table1[Country]),[Country])
VAR __currentCount = COUNTX(Table1,[Country])
RETURN
IF(HASONEVALUE(Table1[Country]),MAX(Table1[Country]),IF(__allCount=__currentCount,"All",CONCATENATEX(VALUES(Table1[Country]),[Country],",")))
nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

Greg_Deckler - always blown away and amazed by your solutions, thanks Greg!