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 project is selected, it should display that specific project name

3. When more than one project is selected, it should display "Multiple"

 

To achieve this, below is my approach,

 

SeletedProject =
var allcount = COUNTX(ALL(Table1[Project Name]),Table1[Project Name])
var currentcount = COUNTX(Table1,SELECTEDVALUE(Table1[Project Name]))
var selectedproject = SELECTEDVALUE(Table1[Project Name])
RETURN
IF(ISBLANK(selectedproject),"All",IF(currentcount > 1 && currentcount < allcount, "Multiple",selectedproject))

 

However, I was able to get "All" and specific project name, but not "Multiple" when i selected more than one project. Insteas it's showing me "All", when i selected multiple projects.

 

Any suggestions?

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"))

3 Replies

  • 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])))
  • PattemManohar's avatar
    PattemManohar
    Community Champion
    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"))

    • slanka's avatar
      slanka
      Helper I
      7 years ago

      I had to do a little tweak of using DISTINCTCOUNT based on my dataset. Other than that this formula works perfect..!! THank you so much!