How to get rid of first row in that calculation?

[Pbiuserr]

Hello, 

I would like to get rid of first row (equipment which have no assigned date from them) out of calculation [Number of Distinct EQ by prod date], so start counting from Jan2010 (capture1), as for instance SQL is doing (capture 2)

My current measure is:

distinct EQ by prod date =

CALCULATE (

    [Number of distinct EQ],

    FILTER (

        ALL ( 'date' ),

        'date'[Date] <= MAX ( 'date'[Date] )

    )

)

Any ideas?

[Idrissshatila]

Hello @Pbiuserr ,

You could remove the blank from the Monthyear column from the filter pane.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Pbiuserr]

Hey

Will it change the calculation also?