Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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. 
     

     

     
     

     

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

HI Anonymous 

Thanks for reaching out to us.

could you share a sample .pbix file for us to troubleshoot? thanks

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.