Forum Discussion

primolee's avatar
primolee
Helper V
6 years ago
Solved

Subtotal error

Hello everyone,   After all this time I use BI, this is the first time seeing such weird thing...     Left side is my data, there are only 3 rows and it is integer type.  Right side is rep...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi primolee ,

     

    I have not reproduced your problem, but I think you have two ways to solve this problem now.
    1. Check the data model and recreate the table relationships.
    2. Create a measure and add it to the table visual.

    Dealing with Measure Totals 

     

    Do you mind sharing your .pbix file?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi primolee ,

 

Do you have the relationship established with Date Table.

 

I think the relationship is missing.

 

Regards,

Harsh Nathani

primolee's avatar
primolee
Helper V
6 years ago

Hello Anonymous ,

 

Funny, there is no date column in this table.  However, it has a relationship link to another table with Date column.

 

When I remove the relationship, subtotal is correct.  However, this relationship is a must so I have to keep the relationship.

 

You can think of this table as a monthly budget table.  I have another table containing daily spending.  I am linking these two tables using Year/Month.

 

How should I solve this?  Thank you.

 

Best regards,

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi primolee ,

     

    Which table is the Year/Month Colum which you have shown in the screenshot above. 

     

    Can you share your .pbix file.

     

    Regards,

    Harsh Nathani

    • primolee's avatar
      primolee
      Helper V
      6 years ago

      Year/Month in the image is from monthly budget table.  And I have another table just for Year/Month.

       

      Monthly Budget

             |    <- 1 to 1, Bi-directional

      Year/Month

             |    <- 1 to N, Bi-directional

      Daily Spending

       

      In the image above, I am pulling both Year/Month and Est. Imp. Per Month from the same table "monthly budget" and there is no other column from other tables.

       

      Just now, I changed the second relationship to single-direction, and the subtotal is correct...  I don't understand...  Even if I don't use any columns from Daily Spending table or Year/Month table, subtotal is wrong...  Shouldn't subtotal simply be adding all rows together?

       

      And here is another problem:

       

       

      I used Buget from Cue Table as my Max value and spending from daily spending as value, max value shown is still 12599999.

       

      This is simply driving me nuts... XD

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi primolee ,

         

        I have not reproduced your problem, but I think you have two ways to solve this problem now.
        1. Check the data model and recreate the table relationships.
        2. Create a measure and add it to the table visual.

        Dealing with Measure Totals 

         

        Do you mind sharing your .pbix file?

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.