Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |