cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kimchizal Regular Visitor
Regular Visitor

Question on the DAX function ALL

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

AvgComparison = CALCULATE(AVERAGE(Order[RevenueDollars]), ALL('Product'[Product_name]))

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?

2 REPLIES 2
Super User
Super User

Re: Question on the DAX function ALL

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 

Community Support Team
Community Support Team

Re: Question on the DAX function ALL

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.