ALL FUNCTION HELP

[Anonymous]

Hi All,

Im in the learning path of DAX...i have read about ALL() and below is my observation

* Acts like a filter modifier
 *Gives distinct value when used with column name 

*Gives combination of values when used with table name

*It ignore the external filter like visual/Slicer and impose the internal filter

However when i was doing practicals im confused how the ALL function is behaving

Numeratr = sum('Order Details'[Sales])
Denominatr = calculate(sum('Order Details'[Sales]),all('Orders'))
Numoverden = divide([Numeratr],[Denominatr],0)

My question is why is it ignoring filters on Lastname column when it is no where mentioned in a measure?

Below is the relationship model

Regards,

HB

[amitchandak]

@Anonymous , all on order should remove all filters on order. So Filter from other table will also go away.

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

[Anonymous]

@amitchandak only the Order table filter get removed .However why is it not slicing the data as per Last name which is coming from Employe table? 

[amitchandak]

@Anonymous , All means on the join ID too. Create a separate table for the Order ID and join with this table. and use all on that table and check.

[Anonymous]

@amitchandak so you mean to say that since order table has employee id as foreign key even that table gets effected with ALL() function ??

[Anonymous]

@amitchandak  can you help me here please, does this mean if a table has foreign key even those tables are affected??