Forum Discussion

CoboleiroBr's avatar
CoboleiroBr
Icon for Helper I rankHelper I
9 years ago
Solved

Only one row for a group

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago
    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")
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago
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")