Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Aggregation discrepancies inside same table

I have one table 'ticket sales' containing the ticket_id, line_id, product_id, price, quantity, date and turnover.    I want to analyze the total turnover of 2020. First I put a filter visual filt...
  • Anonymous's avatar
    Anonymous
    4 years ago

    I managed to find the issue. 

    It turned out that the turnover column contained a massively large number, once positive and once negative. Probably something that was wrongly scanned in the POS and then cancelled. 

     

    As a result, the ticket looked like this:

    + 1 quadrillion

    - 1 quadrillion

    ----------------

    Total turnover = 0

     

    After removing this ticket, the aggregation is correct. I suspect it has something to do with DAX that only allows for a certain number of digits for its numeric values. For instance 123456789 is 'rounded' to 123456000. 

     

    Thank you AlexisOlson. I managed to find it while I was experimenting with a dummy file because of your request. 

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi Anonymous 

 

Can you change the 'sales'[date] <= DATE(2020, 12, 31) to 'sales'[date] <DATE(2021, 1, 1) then check the result?

It might be because of the hours, add hours to your slicer date and check it again.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/