Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?

Need Help

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

     

    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 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    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,