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.

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.

primolee's avatar
primolee
Helper V
6 years ago

Hello v-lionel-msft 

 

Because there are many sensitive data, I tried to recreate the same scenario with very simplified data.  However, everything is perfect and I cannot recreate the error that I encountered previously.  Maybe because there are more relationships involved in my original case.

 

Let me try to play around with the data.

 

Thank you so much for your help!