'Power Pivot DAX formula - Total Subset / Total Set
Hi I'm trying to find the formula for Gender Hire Rate.
Total # of Females Hired / Total # of Hired
I have the measure for counthires which gives me the break out in my pivot, but i can't figure out who to divide the breakouts by the grand total.
Row Labels CountHires Rate Female 2 Rate = 2/12 Male 10 Rate = 10 / 12 Grand Total 12
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|