Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

New DAX column with divide showing wrong result

I created a column in a table with DAX query. the query is pretty simple. Surprisingly it is showing wrong result. Please check the below screen shot for the details.

 

The answer of the Activity column is wrong. For example, considering 4th June data

2762 / 0.8 / 115 = 30.03. But here it is showing 31.7. 

I am not be able to figure out what wrong I am doing here. Please help.

Need Help

5 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Anonymous 

    You formula is not built correctly, please check the modified version:

    Activity = 
IFERROR(
    DIVIDE(
        DIVIDE(
            'Daily Activity Sheet'[Activity Sum],
            'Daily Activity Sheet'[Timesheet Day]
        ),
    'Daily Activity Sheet'[Executive Count]
    ),
    0
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you Fowmy for your reply. I replaced the query with the query that you shared. Unfortunately the problem still persists and showing the same result. I think both the queries (my query and your one) are same but my query was ill structured. 

      • Fowmy's avatar
        Fowmy
        Icon for Super User rankSuper User
        5 years ago

        Anonymous 

        Share a sample PBIX file to know where things go wrong.

        Save it on google or one drive and share the link here.


  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

     

    Is the data displayed in visual already rounded? If so, the original data is still used in the calculation, so there will be errors.

     

    Best Regards

    Janey Guo

     

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