Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Niiru1
Helper V
Helper V

Average of 2 custom measures

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 :
 
Attendance percentage.PNG
 
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

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Niiru1 , Try if this working ?

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

 

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Niiru1 , Try if this working ?

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors