Forum Discussion
Filtering rows based on a lookup match
Hello everyone,
Here's my table 'Approvals':
Index
Submitter
Submitted_datetime
Status
Approved_datetime
FileID
1
Anne <removed by Admin>
4/1/2020 13:00
Pending
...
you can create a column like this
countx(filter(table,[Submitter]=earlier(Submitter) && [FileID] = earlier(FileID) && [Status] ="Approved"),[FileID])
You need to get all blank row for this column
Or try a measure like
countX(filter(summarize(table,table[FileID], "_1",count(table[FileID]),"_2", countx(filter( [Status] ="Approved"),table[FileID])+0),[_2]>0),[FileID])