(Average) Applications per Job Requisition

Hi checkner ,

Ensure that your REQ and CANDIDATE tables are correctly related in your Power BI model. Typically, this would be through the field.

and then you can create a measure:

Applicants Count = COUNTROWS('CANDIDATE')

Next, create a measure to calculate the average number of applicants per requisition. This measure will use the previously created measure

Average Applicants = AVERAGEX(VALUES('REQ'[ReportID]), [Applicants Count])

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.