Forum Discussion

PowerUser123's avatar
PowerUser123
Helper II
3 years ago

Scatter 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 the city selected. 

 

For example, if someone chose Los Angeles, the scatter plot would show all cities in California. If someone chose Dallas, the scatter plot would show all cities in Texas.

 

I can't figure out how to get this to work.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    PowerUser123 , 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