Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incorrect Totals

Hello,

The data in my table is correct.  But, the totals is not matching up, or not showing at all.

Pretty sure it has to do with the relationship.  But when I change it, the data in my table changes and becomes incorrect.

The data in the table is filtered down to a specific version, but I beleive the totals is summing all the versions.

Here is a view of the table:

The totals should be: 9,565 | 12,127 | 21,692

 

Also, here is view of the relationship between the tables.

 

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, Thanks for the response.

    They are measures, created through other measures in the Projectionfinal table.

    • Keegan_Patton's avatar
      Keegan_Patton
      Advocate II
      3 years ago

      I had a similar issue lately, you could try this and see if it works, alot of times a SUMX statement with a nested SUMMARIZE as the table, and calling the measure needed in the 4th argument of SUMMARIZE does the trick, Let me know if that works!

      Test =
      VAR yourmeasure = SUM(your_column)
      RETURN
      SUMX(
          SUMMARIZE(
              'Your Table',
              'Your Table'[Column1],
              "Calculated",
              yourmeasure
          ),[Calculated]
      )
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I gave it a try, but ended up with the same data in the table and the same overstated total as before.

        I am wondering if I need to address the issue of why there is no total for the Dig Next Week Net at all?

        As, it is a part of the Dig Stops calculation.  The first three data column's data and totals are correct.  The next column's data is correct, but no total.  The last column's data is correct, but total is overstated and the same total as the 4th column's.

        The date field is from a seperate table, dimdate.

        These are the measure, all created in the Projectionfinal table, in case it helps.

         

         

         

         

         

         

         

         

         

  • Keegan_Patton's avatar
    Keegan_Patton
    Advocate II
    3 years ago

    Hello Anonymous are the columns 'Dig Stops', 'Print Stops', and 'Total Stops' columns or measures?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Morning,

      All three are measures.  Was just cosidering if I need to make them Columns?

       

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Just chiming in to hopefully get some votes for this idea:

    First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

    This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

    Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
    https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

    Also: https://youtu.be/uXRriTN0cfY
    And: https://youtu.be/n4TYhF2ARe8