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

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!