Forum Discussion
Solved
Newbi - Help Filtering Matching Values Within the Same Table
Hello all! I'm new to Power BI and I'm sure there is a simple answer for this, but I'm stumped. I have the following table: Each ticket_number with the type "Incident" should have a valu...
Hi,
You may download my PBI file from here (my signature).
Hope this helps.
HI,
I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.
Incident count expected result: = VAR _currentrow = MAX ( Data[Ticket_number] ) VAR _t = FILTER ( Data, Data[Type] = "Problem" ) VAR _problem = FILTER ( ALL ( Data ), Data[Problem_id] = _currentrow ) RETURN IF ( COUNTROWS ( _t ) = 1, COUNTROWS ( _problem ) + 0 )
HI,
I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.
Incident count expected result: =
VAR _currentrow =
MAX ( Data[Ticket_number] )
VAR _t =
FILTER ( Data, Data[Type] = "Problem" )
VAR _problem =
FILTER ( ALL ( Data ), Data[Problem_id] = _currentrow )
RETURN
IF ( COUNTROWS ( _t ) = 1, COUNTROWS ( _problem ) + 0 )
Thank you for your help. This worked exactly as desired. It even accounted for another scenario I had not considered, which is if the problem_id for the current row is greater than the ticket_number.