Attached is my Gender Pay Gap dashboard that I have just put together. Given the recent discussion about have proper totals, I have doubts about the totals I get in my report and need your help.
The report looks at the Median and Mean of salaries across the four quartiles. Given the small differences in each quartiles, I dont believe the total gap should be as much as it appears on the report.
I would be grateful if you could test my DAX calculation for Median and Mean and then let me know I can get the appropriate Totals.
Gender Pay Report.pbix (148.7 KB)