Forum Discussion
Absent Percentage Per Employee Distribution
Hello, for the argument sake let us assume that we have following data, Dertment Count of EMPID No of Days Absent Department 1 25 114 Department 2 35 108 Department 3 55 7...
Hi Ashfaq,
You can try to use following measure if it works for your scenario:
Measure =
VAR _curr =
CALCULATE (
SUM ( Table[No of Days Absent] ),
ALLSELECTED ( Table ),
VALUES ( Table[DertMent] ),
VALUES ( Table[EmpID] )
)
VAR _total =
CALCULATE (
SUM ( Table[No of Days Absent] ),
ALLSELECTED ( Table ),
VALUES ( Table[DertMent] )
)
RETURN
DIVIDE ( _curr, _total, -1 )
Regards,
Xiaoxin Sheng
Anonymous Thankls for your input,
I applied all the steps you explained above, I do get 1 as value foe each department,
Wherein I need to distribute them as per Employees and Days absent.
Hi Ashfaq,
Can you please share a pbix file with some sample data and expected result for test? In your sample, it only contains summarized records.Regards,
Xiaoxin Sheng