Forum Discussion
PowerUser123
Helper II
Helper IIScatter Plot - Ignore single filter, show respective group
I have a table that has cities and the respective state they are located in. I have a filter for city where a user selects one city. I'd like my scatter plot to show all cities based on the state of ...
amitchandak
Super User
Super UserPowerUser123 , For that Slicer, need to be on the independent city Table
cities is joined dim table and city is independent date table
Measure =
var _tab = summarize(cities, cities [City] in allselected(CIty[City]) ), City[State])
return
calculate(Sum(Table[Value]), filter(cities, cities[State] in _tab)
Power BI Exclude selected Slicer value, Independent Table: https://youtu.be/lOEW-YUrAbE