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 )
Thank you for your help. This also achieved the desired result.
You are welcome.