Forum Discussion

slanka's avatar
slanka
Helper I
7 years ago
Solved

Dynamically change the title through filter selection

Hello All,   I need to change the title dynamically when filter selection is changed.   1. When the report open (no specific projects are selected) it should display "All" 2. When ONLY one proje...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    slanka Please try changing your measure as below

     

    SeletedProject =
var allcount = COUNTX(ALL(Table1[Project Name]),Table1[Project Name])
var currentcount = CALCULATE(COUNTROWS(Table1),ALLSELECTED(Table1[Project Name]))
var selectedproject = SELECTEDVALUE(Table1[Project Name])
RETURN
IF(currentcount=1,selectedproject,IF(currentcount=allcount,"All","Multiple"))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Not exactly what you are looking for.. but have you tried COUNTROWS(ALLSELECTED))?

 

 

Shows either a single college name or College (M) if  multiple selected

-College Name- = IF (COUNTROWS(ALLSELECTED(View_RefCollegeOfInterest[College Short Name])) > 1, "College (M)", FIRSTNONBLANK(View_RefCollegeOfInterest[College Of Interest], ALLSELECTED(View_RefCollegeOfInterest[College Of Interest])))