Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX IF statement

Dear community,   I've got the following formula: measure = IF(FILTER('rapportage'; 'rapportage'[Lesson Completion] = "completed" || 'rapportage'[Lesson Success] = "passed"); TRUE();FALSE())   ...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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,