Forum Discussion
Solved
Average without Filter context
Hi. Im trying to create a measure (average of grading), with has filter context with the classes(Math, history, geographics), but doesnt change when i filter a student name. My tablle have the F...
Hi DAsilar
Try to use the REMOVEFILTERS DAX function to create a measure, something like this:
Average = CALCULATE( AVERAGE( table[Test_grading] ), REMOVEFILTERS( table[Students name] ) )If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi DAsilar
Try to use the REMOVEFILTERS DAX function to create a measure, something like this:
Average =
CALCULATE(
AVERAGE( table[Test_grading] ),
REMOVEFILTERS( table[Students name] )
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Thanks, It was exactly what i need.
Works perfectly.