Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBI Calculation

Hi Everyone, how can I fix my calculation in powerBI. For example I need to calculate agent Quality Score per Day wherein the formula I used is 1-Error Rate. I'm getting the correct number however, I...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

here's the sample visual showing 100%, last data should be 96.82%

 

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Anonymous ,

    If possible, can you share the formula that you are using?

    Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago
      I just used straight formula: QC = 1-[Error Rate%]
       
      wherein 1 is equivaent to 100%
      Error Rate% = CALCULATE(SUM('07 QC Consolidated'[Weighted Errors])/SUM('07 QC Consolidated'[Expected Points to Earn]))
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous ,

        Do you mean that QC value for the weekending "WE1105" should be 96.82% rather than 100%? According to the formula of your provided measures [QC] and [Error Rate%], it seems OK. Could you please provide some sample data especially the one for weekending "WE1105"  in the table '07 QC Consolidated' (exclude sensitive data) with Text format in order to make troubleshooting and give you a suitable solution? Thank you.

        Best Regards