Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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