Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sum doesn't work properly

Hello,

Can someone explain this? Below are two tables, both are filtered by 2 same Transactions. The first table shows the Adjustment break down correctly, however the second table doesn't do the sum aggreagate correctly. 

Need Help

4 Replies

  • VasTg's avatar
    VasTg
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Anonymous 

     

    The first table is driven by warehouse exit date. Is it possible that you have additional dates? Or is warehouse exit date reside in a different table than adjustments?

     

    Is adjustments a direct summation or a DAX measure? please post the DAX ..

     

     

    If it helps mark it as a solution

    Kudos are nice too

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

    Share the formula Adjustment. If it has something to do with row-level calculation.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Exit Warehouse Date resides in a same table. Adjustments is a column and I'm doing aggreagate function (sum). I also created a quick measure (Adjustments) but it shows same incorrect numbers.

       

      Items Sold table has no other dependencis. It's completely independent.

      • v-eachen-msft's avatar
        v-eachen-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to OneDrive and share the link here.