Forum Discussion

Whibley92's avatar
Whibley92
Icon for Helper II rankHelper II
2 years ago
Solved

Filtering/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...
  • Anonymous's avatar
    Anonymous
    2 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