Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 2 tables linked by Client Number with a 1 to Many relationship. I'm trying to determine the Accuracy Rate. The below image is with the following formula in Accuracy Rate -
This works, however, the "Accuracy Rate" needs to be...
Accuracy Rate = 1 - CALCULATE(SUM(BenchmarkTbl[Claim Count])/SUM(BenchmarTbl[TotalTransactions]))
But when this change is made, it seems to lose the relationship, just from adding the "1 - ".
Appreciate any assistance.
Thanks.
Solved! Go to Solution.
Substituted the "1" with "Volume/Volume" and it works correclty now.
Substituted the "1" with "Volume/Volume" and it works correclty now.