Average with conditional statement

[Anonymous]

Hello Guys,

I have this table, and I want to calculate the average of results passed (so calculating only results >=5.5) and then show it for each course. 

plz help

[AlB · Accepted solution]

Hi  @Anonymous 

Try this, where Table1 is the table you show

1. Place Table1[Course] in the rows of a matrix visual

2.  Create this  measure and place it in vlaues of the matrix visual:

Measure =
CALCULATE ( AVERAGE ( Table[result] ), Table[result] >= 5.5 )

[Anonymous]

It works, thank you so much.