Forum Discussion

ET2018's avatar
ET2018
Frequent Visitor
8 years ago
Solved

How to use count values in column by using Measure?

 

I need to count number of Train # appear by date. 

However, as there are 3 classes per train, if I use count the number of Train # will be multiplied by 3.

May I know how to use Measures to count Train # per day?

 

Thanks!

 

 

  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi ET2018,

     

    To achieve your requirement, you can use DAX formula below:

    Number of Train# Per day = CALCULATE(DISTINCTCOUNT(Table1[Train#]), ALLEXCEPT(Table1, Table1[Date]))

     

    Regards,

    Jimmy Tao

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi ET2018,

     

    To achieve your requirement, you can use DAX formula below:

    Number of Train# Per day = CALCULATE(DISTINCTCOUNT(Table1[Train#]), ALLEXCEPT(Table1, Table1[Date]))

     

    Regards,

    Jimmy Tao