Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@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"))
Proud to be a PBI Community Champion
@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"))
Proud to be a PBI Community Champion
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |