Non intuitive total

[fosterXO]

Hi,

Im having a logic doubt problem that I hope you can help with.

I have a column with Orders, Distinct Customer, Orders per Distict Customer. 

orders  = SUMX(Orders,Orders[Count])

distict Customer = DISTINCTCOUNT(Orders[Customer_code])

orders per distinct cust = [orders]/[distict Customer]

All the numbers in that table are correct. However, the 2022 number is not intuitive. It should be around 56.

How would you enforce that?

[tamerj1]

Hi @fosterXO 
You may try something like:

distict Customer =
AVERAGEX (
    SUMMARIZE ( 'Table', [Year], [Month] ),
    CALCULATE ( DISTINCTCOUNT ( Orders[Customer_code] ) )
)

[FreemanZ]

hi @fosterXO 

it is not intuitive , because distinctcount is semi-additive, or because one Customer_code could present at multiple months, but it is counted once only in Year 2022.  Make sense?

[fosterXO]

Yes, the question would be how to show something that is more intuitive for users. Maybe an average?