Forum Discussion

fosterXO's avatar
fosterXO
Frequent Visitor
3 years ago

Non intuitive total

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?

DAX
Formula
power bi
total

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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's avatar
      fosterXO
      Frequent Visitor
      3 years ago

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

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi fosterXO 
    You may try something like:

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