Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

Mohan128256 Would love to have the PBIX for this for testing. However, you might try something like this as you are calculating the same table twice in your code:

VAR _Table = CALCULATETABLE( 'Inventory Snapshots', KEEPFILTERS('Inventory Snapshots'[Snapshot Weekly?] = "Y"), KEEPFILTERS('Calendar'[445 Year Week Offset]=0))
VAR _Onhand_StdCost = SUMX( _Table, [On-hand StdCost$])
VAR _PickedQty = SUMX( _Table, [Picked Qty])
  • Mohan128256's avatar
    Mohan128256
    Helper IV
    2 years ago

    Greg_Deckler  thanks for your reply.


    I have sent you the personal message with the report google drive link.

     

    Will be waiting for your reply with thousand open eyes. ğŸ˜ƒ

     

    Thanks,

    Mohan V.