Forum Discussion
ALL FUNCTION HELP
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
5 Replies
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/
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?
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.
