DAX Help Needed - Count of employees above median salary

[Anonymous]

I want to create a DAX measure to calculate count of employee positions whose salaries fall below the median (< median).

The median salary is in a separate table from the employee data. I am new to DAX and am having trouble creating workable DAX for this.

Any ideas or a sample DAX to solve this conundrum?

I appreciate any help.

[MattAllington · Accepted solution]

Every DAX formula depends on the table structure and the relationships. It is very difficult to give you advice without understanding exactly what the tables of data look like.  It also depends on how large your data is as to what the best approach will be. If it is a relatively small data set, say less than 10 or 20,000 employees, I would suggest just take a simple approach using a many to many relationship. This can be dangerous, but it is fine as long as you do it right. 

i suggest you post some sample data

[Anonymous]

Thanks for your help, Matt! This is actually for someone else. I won't be given access to the Power BI file (including the relationships and table structure) unfortunately.

I appreciate your assistance nevertheless. Enjoy the holidays.