Forum Discussion
Average with conditional statement
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
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 )
2 Replies
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 )