Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

NEED HELP ALLEXCEPT function

hi All,   amitchandak  ALLEXCEPT function is not working as expected..Ideally it should retain filter which has been specified in argument and remove all external filters please correct if i need ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    Your example is the same as my first example. The field you are using in the table visual is from a dimension table (Products), so you need to write the expression as:

     

    AllExcptProductName = CALCULATE(SUM('Order Details'[Sales]),ALLEXCEPT('Order Details',Products[ProductName]))

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi PaulDBrown 

I really appreciate your brief explanation ....What if the fact and dimension lies in one table only as in my pbix ....why is DAX so complicated?

 

Regards,

Husna

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

Your example is the same as my first example. The field you are using in the table visual is from a dimension table (Products), so you need to write the expression as:

 

AllExcptProductName = CALCULATE(SUM('Order Details'[Sales]),ALLEXCEPT('Order Details',Products[ProductName]))