Fill Rate Formula Not Calculating Appropriately

[Anonymous]

Hello,

I have a fill rate key measure that doesn't appear to be working. The fill rate is calculating correctly in the first table (shown below) that displays Receipt Date, Vendor Name, PO Number, and Item Number. It does not appear to be calculating properly in the second table (shown below) which includes Vendor Name and Item Number. I think this may have to do with my table relationships but I haven't been able to figure it out. I've also dropped the pbix file in a DropBox folder and linked below.

Fill Rate = DIVIDE([Total Qty Receipt],[Total Qty Ordered])

https://1drv.ms/u/s!AiFttrDOn_FqgQ0FMacHzVmVu9mh

Table 1Table 2

Any help is appreciated.

JDaly

[v-chuncz-msft · Accepted solution]

@Anonymous ,

In the Visualizations pane, right-click [Qty Received] dragged to Values, and change the aggregation to Sum.

https://docs.microsoft.com/en-us/power-bi/service-aggregates