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...
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