Forum Discussion
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...
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.
This looks strange indeed. Can you create a dummy file that reproduces this problem?