Forum Discussion
Whibley92
Helper II
2 years agoFiltering/duplicates/count words - not sure where this would sit in Power BI topics
I have a spreadsheet with a list of 2 courses, learners names and completion status. I have made one table to show learners incomplete in one course. I have made another table to show learners in...
- 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
bhanu_gautam
Super User
2 years agoWhibley92 , Try using below method
Result Measure = IF ( COUNTROWS ( FILTER ( YourTableName, [Group 2] = "X" ) ) > 0, "Red", "Green" )
Please accept as solution and give kudos if it helps