Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Grand Total giving me wrong Number

 

Hi ,

 

As per the snapshot if below i m getting a wrong value for Col1 which is grand total. Ideally its Value should be Col1 / Col3 which is woring well for every row. But the Grand total dont match. the Dax columns are staright copies. =col1/col2. Can you help with the same

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Please clarify. You said "col1" should be "col1/col3"...

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Its should Be col1 =  Col2/Col3. If you see the row are matching(M = V ) but Grand Total are not matching. 

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago
    Hi,
    As per your screenshot given there is a different value coming for row label 'E' i. e. T/U value against E is showing positive value and column 1 showing negative value.

    Please correct your data accordingly.

    Please give Kudos to this effort and accept this as a solution if It helps you!
  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. thanks!