Forum Discussion
Use a Filter in a ALL condition
Hello,
I have a dataset of physical performance during games (distance covered, high-speed distance, acceleration, ...) and I created a measure to compute average according to several conditions like that : CALCULATE( Average with condition, ALL(Games)).
However, I would like to know if it is possible to add a condition inside the calculate fonction such as : CALCULATE( Average with condition, ALL(Games.Minutes > 60)).
I hope my explications are clear enough 😅
Thanks in advance for your time and your help
3 Replies
Just type CALCULATE( Average with condition, ALL(Games), ALL(Games.Minutes > 60))
Each , adds a new filter.
However I am not sure you want to use the all function since it returns all rows in a table without the use of any filter.
So, do you have an idea of which function will be a better use than ALL() ?
It depends on what you want to do, but I am not even sure you need anything. If you just pick the table and the colum and only wants to include rows where the value is higher than a specifik number you can just pick the table and colum and write something like this in Dax.
Games =
CALCULATE(Average with condition,
table[colum] > 60))
