Use a Filter in a ALL condition

[maxduff59]

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 

[ThomasWeppler]

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.

[maxduff59]

So, do you have an idea of which function will be a better use than ALL() ?

[ThomasWeppler]

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