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 l...
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))