Need Grand Total differently

[sjoshi]

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

[amitchandak]

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

[Fowmy]

@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