My visual totals are not maching with the exported data

[Anonymous]

Hi,

Need your help with this problem

I have this model

The primary key for the union is the ORDER_DATE and for this calcultaion I am only using the Customers Table

The total is 1491 for new users with a web account but when I export the data and sum each day the real total is 1797.

Measures:

# Customers - New = CALCULATE(DISTINCTCOUNT(Customers[CUSTOMER_SPK]),Customers[ORDER_DAYS_AFTER_FIRST_ORDER]=0 || Customers[ORDER_DAYS_AFTER_FIRST_ORDER] = -1)

# Customers - New Mobile = CALCULATE([# Customers - New] ,

FILTER('Customers','Customers'[ORDER_SOURCE]="mobile"))

# Customers - New Web = CALCULATE([# Customers - New] ,

FILTER('Customers','Customers'[ORDER_SOURCE]="web"))

[Ashish_Mathur]

Hi,

That answer may be correct if the same Web customer transacted on different dates.

[Greg_Deckler]

@Anonymous Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[AlexisOlson · Accepted solution]

DISTINCTCOUNT is not additive so I wouldn't expect the total to be the sum of the values on each day. For example, if Day 1 has Customers #1, #2, and #3 and Day 2 and Customers #2, #3, and #4, then there are only 4 distinct customers for Day 1 and Day 2 combined (summing 3 + 3 would double count #2 and #3.)

You can force the total to be the sum of the parts by explicitly iterating over each day but it isn't clear to me if that makes sense in your situation or not. If you do need this, you may want to take a look at @Greg_Deckler's post here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907

Recommended reading:
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/