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.

amitchandak's avatar
amitchandak
Super User
6 years ago

primolee , what is the data type. If it decimal change t whole number and check

  • primolee's avatar
    primolee
    Helper V
    6 years ago

    It is integer (whole number), and there is no decimal at all.  Original data came from Excel and it is 4200000 in each row.