Forum Discussion
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 ...
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 , Please refer to this -https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
And check if this can help you.
Or
Can you share sample data and sample output in table format? I need to try and check