Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measures Calculating Incorrectly at Line Level

Hello,   Hoping someone can help me. I'm trying to do something very simple and basic in Power BI, yet each attempt using different methods is coming up incorrecct as well.   I have inventory it...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    AlexisOlson I was finally successful and was able to create the proper sum per item using this measure:

     

    Current Qty = SUMX(SUMMARIZE(vw_TubingShortage_InventoryUsage,[Item Name],[CurrentQty]),[CurrentQty])
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    It's doesn't make sense to me why that would necessarily be the "correct" sum but you could do something like this:

    SUMX (
    SUMMARIZE ( Table1, Table1[Item Name], Table1[Current Qty] ),
    Table1[Current Qty]
)

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

This definitely looks odd but it's hard to diagnose without seeing your file. Can you share a file that enables us to replicate the issue (either share your existing file with anything sensitive removed or create a new dummy file)?

    • AlexisOlson's avatar
      AlexisOlson
      Super User
      4 years ago

      Thanks.

       

      What's happening is that in your first table, it's grouping distinct Item Name and Current Qty combination. Some of these combinations appear multiple times though, which is why they add up to a larger number than you expect.

       

      If you add DATECHG to the table, it becomes more obvious what's happening.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        AlexisOlson thank you.

        So how would I solve the issue of summing the amounts to reflect the correct value regardless of the date?  The sum should be 130.

         

        Thank you.