Forum Discussion

sjoshi's avatar
sjoshi
Icon for Helper II rankHelper II
5 years ago

Need Grand Total differently

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

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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