Distinct Count This Month

[kristenmcnelly]

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

[Jihwan_Kim]

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 () )
    )
)