Measure to count items based on a filter on another column

[Noob7]

I am very new to this and I cannot even make a simple measure. I need help in counting the Ids that are already Closed. I really appreciate your help.

[Idrissshatila]

Hello @Noob7 ,

Use the following measue:

Closed Items = calculate( count( 'YourTableName'[ID]), 'YourTableName'[Status] = "Closed")

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

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Noob6]

Hi Idrissshatila. It's not working on my end. As shown in the image above in cannot find the Incident_Reports[Status]. The options showing up are columns from another table.