Forum Discussion
Solved
Conditional filtering based on specific row value, with several dashboards
Hello I have a list of countries and then there is a special "all" also included, which is made for one specific visual, to show the overall value. Other visuals in the dashboard don't have "a...
Hello Xiaoxin,
Thank you for you effort!
I found a way to work around it, it is not perfect but looks like that.Measure = if(iscrossfiltered([averageAge]),FIRSTNONBLANK(age[averageAge],
[averageAge]),CALCULATE(FIRSTNONBLANK(age[averageAge],[averageAge]), FILTER(age,[country] = "All")))
I hidde "all" from slicer view, so when nothing is selected then the averageage is 39 and the unit is what it should be and if a country is selected then numbers will be correct.
Thank you again for your effort!
Kaarel
vannipart be really helpful here if you could provide some screen shots. visuals give better understanding