Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Hi @kimchizal,
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.
Best Regards,
Hi @kimchizal
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |