Forum Discussion
Anonymous
7 years agoNot applicable
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
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
- AnonymousNot 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.
- AnonymousNot applicableunluckily its a many to many
anyway thanks for your help.