Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an easy measure that does the following
// All Other Employees Measure
Sum(
Aggr(
{< Employee= >} // Ignore selection of Employee
Count({< ACTION_CODE = {'LABOR_OFF'} >} distinct MainSFC) * Avg_time,
MainSFC, Employee
)
)
/
(
Sum(
Aggr(
{< Employee= >} // Ignore selection of Employee
Count(distinct WorkingDay) * 7.5 * 60,
Employee
)
)
-
Sum(Absence) * 60
)
I then add another measure, which is the same but with only TOTAL suffix added to the two SUM functions.
This results in a table with the following values
But as you can see, while the values on the left are correct, the results on the right are not what I was looking for. The right one should be all 75.4% for each single row, because it's the total value at the top of the first column to the left.
Let's make an example:
Measure 1 | Total measure |
average: 50 | average: 50 |
25 | 50 |
75 | 50 |
So the final result should be 50, because the 2 rows gave me a total average of 50, and all rows in the second measure should thus have 50.
Wow thank you so much @PrashantSangle , it's been a rough ride but your help has solved this. Thank you again, wish you a good continuation.