Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kristenmcnelly
Frequent Visitor

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 1
Jihwan_Kim
Super User
Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors