For the DAX function ALL applied on a specific column, does that ignore any other filters/slicers that might affect that column?
Say we have 3 tables of Order, Product, and Manufacturer all with some relationships to each other. And I have 2 slicers, one on Product.Product_name and Manufacturer.Country.
If I have
does this ignore changes on the Manufacturer.Country filter since there's a relationship between the two tables?
I'm just not seeing my data change when I update the Manufacturer.Country slicer.
If possible, I'd like this measure AvgComparison to ignore filters on the exact Product[Product_name] field but apply any filters from the Manufacturer[Country] field. Is there a way to denote that with a DAX formula or function?
You need to show the structure of your tables and detail their relationships at the very least. "... all with some relationships to each other... " is not quite enough to figure out what is going on. Or share the pbix
Your formula seems good enough to get the desired result. It could be something wrong with your mode. Please share a sample. Please mask the sensitive data first.