Forum Discussion
Filtering/duplicates/count words - not sure where this would sit in Power BI topics
- Anonymous2 years ago
Hi Whibley92 ,
As you said, there can only be two arguments after the filter, so if you want to make a judgment based on two conditions, then you can use the logical operator || to splice the two arguments together.Measure
Incomplete Both Courses = COUNTROWS( FILTER( SUMMARIZE( FILTER( 'Table', 'Table'[Status] = "Incomplete" || 'Table'[Status] = "Pending" ), 'Table'[Learner number], "Incomplete Count", COUNT('Table'[Status]) ), [Incomplete Count] = 2 ) )Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Whibley92
If you are using Power Query
Please Append the two table as NEW table
Then keep only Duplicate rows in Learner Names. This will be third table with Name both course incomplete.
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin