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...
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.
amitchandak so you mean to say that since order table has employee id as foreign key even that table gets effected with ALL() function ??
amitchandak can you help me here please, does this mean if a table has foreign key even those tables are affected??