Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Any help is appreciated.
JDaly
Solved! Go to 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
@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
User | Count |
---|---|
81 | |
79 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |