Forum Discussion

kristenmcnelly's avatar
kristenmcnelly
Frequent Visitor
3 years ago

Distinct Count This Month

Hello,

 

I would like to create a measure that takes the distinct count of an ID with a completed date in this month.

 

I have tried CALCULATE(DISTINCTCOUNT('Table'[ID]), MONTH('Table'[Completed Date] = MONTH(TODAY() && YEAR('Table'[Completed Date] = YEAR(TODAY())))))

 

This appears to be taking the distinct count but not filtering by completed this month.

 

Thanks,

Kristen

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please try below measure whether it suits your requirement.

     

    new measure: =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[ID] ),
    FILTER (
        ALLSELECTED ( 'Table'[Completed Date] ),
        MONTH ( 'Table'[Completed Date] ) = MONTH ( TODAY () )
            && YEAR ( 'Table'[Completed Date] ) = YEAR ( TODAY () )
    )
)