Forum Discussion

SchoolBoy's avatar
SchoolBoy
Frequent Visitor
8 years ago
Solved

Count and sum it up

Hello, I have a little problem :)  How can I calculate a total monthly occurrence of unique customer numbers? For example: there is a sales table including invoice date, customer number, invoice...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi SchoolBoy

     

    Try this MEASURE

     

    Measure =
SUMX (
    VALUES ( Table1[Day] ),
    CALCULATE ( DISTINCTCOUNT ( Table1[Customer] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi SchoolBoy

 

Try this MEASURE

 

Measure =
SUMX (
    VALUES ( Table1[Day] ),
    CALCULATE ( DISTINCTCOUNT ( Table1[Customer] ) )
)
SchoolBoy's avatar
SchoolBoy
Frequent Visitor
8 years ago

Thank you very much, it works very well! :)