I have a table called Logging. There columns Date, TicketId, Step and Result. Some TicketID have a Result = "Error", Step = 8, and if it was fixed later on, it will recieve new row with Result = "Successfull" and Step = 2.
There is also matrix with calculated measure that counts unique TicketId with Step = 8.
I need to calculate new measure to look on TicketID with error, take this ID, look on its own table Logging ones again and try to find this ID with a Status = "Successfull".
The measures to calculate TicketID with errors look like this:
First: LogDistcount_ = DISTINCTCOUNT(Logging[TicketId])
Second: Errors_dist = CALCULATE(Logging[LogDistcount_], Logging[Step] = 😎