topic Re: Need Grand Total differently in DAX Commands and Tips

Need Grand Total differently

sjoshi — Thu, 29 Oct 2020 06:09:42 GMT

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

Re: Need Grand Total differently

Fowmy — Thu, 29 Oct 2020 08:20:20 GMT

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 🙂

YouTube LinkedIn

Re: Need Grand Total differently

amitchandak — Thu, 29 Oct 2020 08:20:35 GMT

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])