Forum Discussion
Unexpected ALL() Behavior
Hi everyone, I am a DAX beginner and I have been having an issue understanding the ALL() function. Take for example this scenario from the titanic dataset: So what I would like to disp...
Anonymous
In your example did you pull the sex column into the visual from the Sex table or the Train table? You should pull it from the Sex table then I believe your view will work.
Hi everyone,
Thank you for all your answers, they were really helpful.
However, I also found out that if your dimension table contains an "order" column, you need to include the order with the ALL() expression as well for it to work properly.
For instance, if the sex table had a column that looks at the order of male and female to display in a certain way, you would want the expression to be as follows:
Total survived passengers embarked at port = CALCULATE(sum(train[Survived]), all(sex[Sex],sex[Order]))