Hello, I hope every one is good 😎
I have a table that shows customer sales by location and there are customers that purchase from multiple locations. Users currently filter this table to get a list of customers for their selected location, however, when they do this, it only shows the sales for their location. They would also like it to show the sales for the filtered customers from the other locations. I am aware of some of the ways of preventing selections affecting measures, but they do not appear to work for this use case, as they bring back the records of customers that have purchased in other locations but not the location selected. Is there a way of ensuring that all measures conform to the set of customers produced by the selection of the location?
Thanks
NSB