Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

count repeated values under different filter

I'm trying to count "D5" in column
Notifications where
1) column item is not blank
2) column status=Done
3) Equipment# has a repeated value When Notification =D1
the count in my example table is1
(Only one D5 notification that has an Item and its status =Done where D1 notification is issued on the same
equipment#)

example table:
Noti. Item Eq# Status
D5 AAA 111 Pending
D5 BBB 222 Done
D5 CCC 333 Done
D5 null 444 Done
D1 null 111
D1 null 222
D1 null 444
D1 null 888
D1 null 999

I need help from your experience since i've tried all what I know so far on power bi and did not work
thanks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I think the simplest solution is to split the tables i.e. D1 in rows in 1 table, other D's in the other table.   You can then join the tables using equipment number and your other conditions.  This will only work if there is 1-Many relationship.  You can use Power Query to do this.

    • Anonymous's avatar
      Anonymous
      Not applicable
      unluckily its a many to many
      anyway thanks for your help.