Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |