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. 

Anonymous's avatar
Anonymous
Not applicable
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.