Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |