DAX IF statement

[Anonymous]

Dear community,

I've got the following formula:

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

It gives me an error: 

Measure refers to multiple collums. Why exactly?

[v-lid-msft]

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,

[v-lid-msft]

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,

[Greg_Deckler]

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