How count only confirmed requests

[Anonymous]

Hi everyone,
I have a table with requests and they have statuses like: "In progress", " Confirmed"...

I made a measure to count only confirmed requests:

CONFIRMED = CALCULATE( COUNTROWS('REQUESTS'), 'REQUESTS'[STATUS] = "confirmed")

I used it for a few charts. When I  have chosen "Declined" on one of them in the table shouldn't be any "confirmed". I don't know how to explain it, so below I sent a print screen.

Thank you in advance for your help 🙂

[Whitewater100 · Accepted solution]

Hello:

You can try:

Confirmed = COUNTROWS(

Filter(

Requests,

Requests[Status] = "Confirmed")

)

I hope this works well for you!