Forum Discussion
How count only confirmed requests
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 🙂
Hello:
You can try:
Confirmed = COUNTROWS(Filter(Requests,Requests[Status] = "Confirmed"))I hope this works well for you!
1 Reply
Hello:
You can try:
Confirmed = COUNTROWS(Filter(Requests,Requests[Status] = "Confirmed"))I hope this works well for you!