Forum Discussion
Get the right measure
Hi,
I have the table below, and current measure to calculate the
YTD Race Rate = [ YTD Start Headcount by Race]/[ YTD Start Headcount ALL Race] (results are in column YTD Race Rate)
And what I need instead is to get:
YTD Race Rate =YTD Start Headcount by Race/Total YTD Start Headcount ALL Race which is the "Reuired Results"
| Race Name | YTD Start Headcount by Race | YTD Start Headcount ALL Race | YTD Race Rate | Required Results |
| A | 18 | 114 | 15.8% | 15.8% |
| B | 11 | 105 | 10.5% | 9.6% |
| C | 2 | 111 | 1.8% | 1.8% |
| D | 5 | 84 | 6.0% | 4.4% |
| E | 1 | 23 | 4.3% | 0.9% |
| F | 1 | 91 | 1.1% | 0.9% |
| G | 4 | 84 | 4.8% | 3.5% |
| H | 72 | 114 | 63.2% | 63.2% |
| Total | 114 | 114 |
To give you more context about the measures above, below are the measures I have for above table:
1- YTD Start Headcount = CALCULATE(COUNT(Table Name[Job Req]), DATESYTD(able Name[CF - Hire Date (Job Req)]),able Name[Job Requisition Status]="Filled",TA_Talent_Feed[Country]="Country Name")
2- YTD Start Headcount ALL Race= CALCULATE(COUNT(Table Name[Job Req]), DATESYTD(Table Name[CF - Hire Date (Job Req)]),Table Name[Job Requisition Status]="Filled",Table Name[Country]="Country Name",ALL(Table Name[Race]))
3-YTD Race Rate = [YTD Start Headcount]/[YTD Start Headcount ALL Race]
Anyone could help me with getting the right measure and get the results as the column "required results"?
Thank you!
You're welcome! That shouldn't be an issue. Just update the measure as seen below:
Required Result Measure = VAR Numerator = [YTD Start Headcount by Race] VAR Denominator = CALCULATE ( [YTD Start Headcount by Race], ALL ( 'Table Name'[Race Name] ) ) VAR Result = DIVIDE ( Numerator, Denominator ) RETURN ResultI also update the PBIX linked in the earlier reply.
4 Replies
SteveHaileySolution Specialist
Hello,
Try something like this:
Required Result Measure = VAR Numerator = SUM ( 'Table Name'[YTD Start Headcount by Race] ) VAR Denominator = CALCULATE ( SUM ( 'Table Name'[YTD Start Headcount by Race] ), ALL ( 'Table Name'[Race Name] ) ) VAR Result = DIVIDE ( Numerator, Denominator ) RETURN ResultHere is a link to a PBIX.
-Steve
- SteveHailey
You're welcome! That shouldn't be an issue. Just update the measure as seen below:
Required Result Measure = VAR Numerator = [YTD Start Headcount by Race] VAR Denominator = CALCULATE ( [YTD Start Headcount by Race], ALL ( 'Table Name'[Race Name] ) ) VAR Result = DIVIDE ( Numerator, Denominator ) RETURN ResultI also update the PBIX linked in the earlier reply.