Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Below is the logic of column E. In Total where it is highlighted as red (E column) we want vertical sum of column E 305 highlighted in green color. Similarly for column H we want vertical sum 152401 but Power BI giving total as 145*5612=813740 which is incorrect
E column logic Quantity = abs(sum('Inventory Discrepancy F'[carrier QTY])-sum('Inventory Discrepancy F'[ERP Qty]))
How to fix this? We want E column should be carrier QTY - ERP QTY though
Thanks
Smita
@sjoshi , Try like
E column logic Quantity = sumx(summarize('Inventory Discrepancy F', 'Inventory Discrepancy F' [Item_id], 'Inventory Discrepancy F'[warehouse] , "_1",abs(sum('Inventory Discrepancy F'[carrier QTY])-sum('Inventory Discrepancy F'[ERP Qty]))),[_1])
@sjoshi
Can you try :
E column logic Quantity =
SUMX(
'Inventory Discrepancy F',
abs(sum('Inventory Discrepancy F'[carrier QTY])-sum('Inventory Discrepancy F'[ERP Qty]))
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
16 | |
14 | |
14 | |
9 |