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 have default 100% score for the dates that I don't have raw data on the back end.  Thank you in advance.

 

4 Replies

  • 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]))