Average of 2 custom measures

[Anonymous]

I have 2 measures for attendance %

1.

% Attendance - F = CALCULATE(IF([% Attendance Average 2018-2020]<>1,[% Attendance Average 2018-2020],

IF([% Attendance Average 2018-2020]=1,0)),FILTER('Query1','Query1'[GENDER] = "F"))

2.

% Attendance - M = CALCULATE(IF([% Attendance Average 2018-2020]<>1,[% Attendance Average 2018-2020],

IF([% Attendance Average 2018-2020]=1,0)),FILTER('Query1','Query1'[GENDER] = "M"))

Which results in :

Is there a way to have the average of these two values e.g. 91.88 + 83.89 /2 = 87.88 but when I click male or female filter it will give me e.g. M selected 91.88 or F selected 83.89

Thanks in advance

[amitchandak · Accepted solution]

@Anonymous , Try if this working ?

CALCULATE(IF([% Attendance Average 2018-2020]<>1,[% Attendance Average 2018-2020],
IF([% Attendance Average 2018-2020]=1,0)))