DAX Measure with Conditional Filters

[powerbi_alvic]

Hello guys,
I need help for this requirement.  Number of tickets rejected that have been passed previously(create_time) by commercial queue.

Is it possible to do it with a measure?

Please help! Any advice is welcome.

I appreciate your help guys!

Thank you!

[felipetrin]

Hi!

Try that: 

Number of Tickets Rejected by Commercial = 
CALCULATE(
     COUNTROWS(Table),
     Table[state] = "rejected",
     Table[queue] = "commercial"
)

[stevedep · Accepted solution]

Hi,

This should work for you:

___CountPassedbyCommercialPrev = 
var _dateRejected = CALCULATE(MAX('Table'[create_time]),'Table'[state]="rejected")
return

COUNTROWS (
    FILTER (
        ALL ( 'Table' ),
        'Table'[ticket_id] = SELECTEDVALUE ( 'Table'[ticket_id]) && 'Table'[queue] = "commercial" && 'Table'[create_time] <= _dateRejected )
    )


___CountPerTicket = 
SUMX(VALUES('Table'[ticket_id]),[___CountPassedbyCommercialPrev])

Link to the file here. 

In this video I explain how to approach and build such a measure. Hope its helpfull.

Kind regards,

Steve. 

[powerbi_alvic]

Great job, it is great !!!

Grateful for your help.

[stevedep]

@powerbi_alvic , Welcome, hope you like the video? Thumbs up on the post(s) if you do 🙂

[powerbi_alvic]

Thank you very much for answering.

But, the problem is that the conditions are in a different row (state = rejected, queue = commercial)

I attach pbix file here

https://we.tl/t-57lfjXBWDi