Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Any help would be appreciated.
Ben
Solved! Go to Solution.
@Anonymous , I think you need a measure like
Reject Rate = divide(sum(TroyCert[QtyRejected]),sum(TroyCert[QtyInspected]))
You are a life saver @amitchandak! I thought i tried this already but apparently not. Works as antivipated.
Best Regards,
Ben
@Anonymous , I think you need a measure like
Reject Rate = divide(sum(TroyCert[QtyRejected]),sum(TroyCert[QtyInspected]))
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |