DAX IF statement

Because FILTER returns a table.

 

Complete guess but you probably want:

measure = IF(MAX('rapportage'[Lesson Completion]) = "completed" || MAX('rapportage'[Lesson Success]) = "passed"); TRUE();FALSE())

 

If not, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Hi Anonymous ,

The reason is accurately what Greg has said, but if you want to get result from multi rows, you can try to use the following formula:

 

measure =
CALCULATE (
    COUNTROWS ( 'rapportage' );
    'rapportage'[Lesson Completion] = "completed"
) > 0
    || CALCULATE (
        COUNTROWS ( 'rapportage' );
        'rapportage'[Lesson Success] = "passed"
    ) > 0

 

By the way, PBIX file as attached.

Best regards,

 

Hi Anonymous ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,