Forum Discussion
Calculate total average
Hi all, I am calculating a column called "Comletion". The measurs are Inspection KPI 2 = COUNT('Inspection Staff'[Form ID])-'Employee Transaction'[84 Hours Rule ] 0 or 1 = IF('Inspection S...
I have already address the issue. I re-write the measure of "completion" as follow:
Completion for Job = DIVIDE(SUMX(VALUES('Staff'[User Name]),'Inspection'[0 or 1]),COUNTX(VALUES('Staff'[User Name]),'Inspection Staff'[Inspection Counts for Inspection Crew]))Now the outcoming from both matrix table and graph are equal.
I have already address the issue. I re-write the measure of "completion" as follow:
Completion for Job = DIVIDE(SUMX(VALUES('Staff'[User Name]),'Inspection'[0 or 1]),COUNTX(VALUES('Staff'[User Name]),'Inspection Staff'[Inspection Counts for Inspection Crew]))
Now the outcoming from both matrix table and graph are equal.