topic Re: Non intuitive total in DAX Commands and Tips

Non intuitive total

fosterXO — Mon, 06 Mar 2023 14:30:07 GMT

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?

Re: Non intuitive total

FreemanZ — Mon, 06 Mar 2023 14:59:26 GMT

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?

Re: Non intuitive total

fosterXO — Mon, 06 Mar 2023 17:01:28 GMT

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

Re: Non intuitive total

tamerj1 — Mon, 06 Mar 2023 17:21:00 GMT

Hi fosterXO
You may try something like:

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