PowerBI Calculation

[Aiei2488]

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.

[Aiei2488]

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

[Arul]

@Aiei2488 ,

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

Thanks,

[Aiei2488]

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

[v-yiruan-msft]

Hi @Aiei2488 ,

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