Forum Discussion
Solved
Incorrect Percentage - DAX
Hi everyone, I’m hoping to get some assistance with a DAX measure I created to calculate the percentage of employees in the higher salary range. The overall percentage seems accurate, but when I ...
ronaldbalza2023 - as mentioned, just adding in ALL. so your measure became:
% SalaryRangeHigh = VAR TotalActiveEmployees = CALCULATE( COUNTROWS(_EmployeeDetail), ALL (_EmployeeDetail) , ALL (_EmployeeSalary) , _EmployeeDetail[EmploymentStatus] = "Active", NOT ISBLANK(_EmployeeSalary[ Salary ]) ) VAR ActiveEmployeesHigherRange = CALCULATE( COUNTROWS(_EmployeeDetail), ALL (_EmployeeDetail), ALL (_EmployeeSalary) , _EmployeeDetail[EmploymentStatus] = "Active", NOT ISBLANK(_EmployeeSalary[ Salary ]), FILTER( _EmployeeSalary, _EmployeeSalary[ Salary ] >= _EmployeeSalary[SalaryRangeHigh] ) ) RETURN DIVIDE(ActiveEmployeesHigherRange, TotalActiveEmployees)
Do you have the figures you want? As I can get these:
By using the ALL on both tables.
Hi twofingertyper , on point. How did you achieved it? Thanks 🙂
ronaldbalza2023 - as mentioned, just adding in ALL. so your measure became:
% SalaryRangeHigh = VAR TotalActiveEmployees = CALCULATE( COUNTROWS(_EmployeeDetail), ALL (_EmployeeDetail) , ALL (_EmployeeSalary) , _EmployeeDetail[EmploymentStatus] = "Active", NOT ISBLANK(_EmployeeSalary[ Salary ]) ) VAR ActiveEmployeesHigherRange = CALCULATE( COUNTROWS(_EmployeeDetail), ALL (_EmployeeDetail), ALL (_EmployeeSalary) , _EmployeeDetail[EmploymentStatus] = "Active", NOT ISBLANK(_EmployeeSalary[ Salary ]), FILTER( _EmployeeSalary, _EmployeeSalary[ Salary ] >= _EmployeeSalary[SalaryRangeHigh] ) ) RETURN DIVIDE(ActiveEmployeesHigherRange, TotalActiveEmployees)