Only one row for a group

[CoboleiroBr]

Hello!

I'm new to Power BI and I'd like a help for this problem:

I have a table with ID and Reason Code, like that:

ID Reason Code  Only this row for ID?

1   183                 False

1   1                     False

1   3                     False

2   183                 True

3   183                 True

4   183                 False

4   1                     False

I need to discover if the reason code 183 is followed by other reason codes. I mean, if the reason code 183 is the only row for that id.

Thanks!

[Greg_Deckler · Accepted solution]

Measure = COUNTROWS(Table)

Put this into a table visualization with ID. Filter Measure > 1.

Alternatively, create another table of just unique ID's. Relate the tables. Create a calculated column in this table like:

Column = IF(COUNTROWS(RELATEDTABLE(Table))>1,"False","True")