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 the following table (Left) which contains two columns Material and Batch#, the column "Qty" is coming from the same table as the batch # and "Sum Unrestricted" is coming from a different table, the goal is to compare the qty available at batch level but the column "Sum Unrestricted" is showing the result for the material not for the specific lot that I need. As you can see on the right table, the sum of all the lots is 10820 but the correct total should be 1320. How can I get the result for the lot# only showing on the right table?
Thanks!!!!
Can't help without seeing your data and file. Without these, can't see what is going on in the model.
Phil
Proud to be a Super User!
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 |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |