Forum Discussion
Fill Rate Formula Not Calculating Appropriately
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.
https://1drv.ms/u/s!AiFttrDOn_FqgQ0FMacHzVmVu9mh
Table 1Table 2
Any help is appreciated.
JDaly
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
1 Reply
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