Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mgunnin
Frequent Visitor

Changing a formula is somehow changing my grouping/link

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 - 

       Accuracy Rate = CALCULATE(SUM(BenchmarkTbl[Claim Count])/SUM(BenchmarTbl[TotalTransactions]))
 

mgunnin_0-1659454791452.png

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

mgunnin_1-1659455045999.png

Appreciate any assistance.

 

Thanks.

1 ACCEPTED SOLUTION
mgunnin
Frequent Visitor

Substituted the "1" with "Volume/Volume" and it works correclty now.

View solution in original post

1 REPLY 1
mgunnin
Frequent Visitor

Substituted the "1" with "Volume/Volume" and it works correclty now.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors