DAX Help: Divide the Sum of Two Columns Filtered by Another Column (Inspector)

[Anonymous]

I have been struggling to figure out the proper logic to arrive at the correct value. 

I need to determine the Rejected Rate of Parts per Inspector:

Rejected QTY / QTY of Parts

Since both QtyParts and QtyRejected are summarized columns I figured the function would be as simple as this 

Reject Rate = TroyCert[QtyRejected]/TroyCert[QtyInspected]

It seems that every DAX equation I try doesnt give the proper end value. I cant find where I am making a mistake..

Any help would be appreciated. 

Ben

[Anonymous]

You are a life saver @amitchandak! I thought i tried this already but apparently not. Works as antivipated. 

Best Regards,

Ben

[amitchandak · Accepted solution]

@Anonymous , I think you need a measure like

Reject Rate = divide(sum(TroyCert[QtyRejected]),sum(TroyCert[QtyInspected]))