DAX Measure to Calculate the count of records

[Ramees_123]

I have a table with below fields. I need to find out the count of projects which starts in current year which is 2021. I need to consider the rows only with valid year values.

Project Name        Start             End

Project 1                Q12020        Q42023

Project 2                Q32021        Q42025

Project 3                Q12022        Q12025

Project 4                Junkdata       Junkdata

Please help with dax for creating measure.

[v-stephen-msft · Accepted solution]

Hi @Ramees_123 ,

Try this measure. Because there is a possibility that the project name will be repeated, the DISTINCTCOUNT is repeated.

Distinctcount project =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Project Name] ),
    FILTER (
        'Table',
        [Start] <> "Junkdata"
            && VALUE ( RIGHT ( 'Table'[Start], 4 ) ) = YEAR ( TODAY () )
    )
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL]

= COUNTROWS( FILTER( PROJ, RIGHT( PROJ[Start], 4 ) = "2021" ) )