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 Cu...
DAX
Formula
power bi
total
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi fosterXO 
You may try something like:

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