Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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'...
DAX
measure
power bi
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hello:

    You can try:

    Confirmed = COUNTROWS(
    Filter(
    Requests,
    Requests[Status] = "Confirmed")
    )
    I hope this works well for you!
Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hello:

You can try:

Confirmed = COUNTROWS(
Filter(
Requests,
Requests[Status] = "Confirmed")
)
I hope this works well for you!