Please assist with DAX Calculation

[KellyLo]

Hello - I'm fairly new to using PBI and DAX. I'm hoping someone could assit with a pretty straight forward calculation I need. I have a column of ID's. I need to be able to count a specific ID based on date being >= 2024-05-01. 

[KellyLo]

THANK YOU!

[bhanu_gautam · Accepted solution]

@KellyLo , You can get the desired result using a measure

CountSpecificID =
CALCULATE(
COUNTROWS(YourTable),
FILTER(
YourTable,
YourTable[ID] = "YourSpecificID" && YourTable[Date] >= DATE(2024, 5, 1)
)
)

Please replace table and column name with what you have in your report