Forum Discussion
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()) ...
Greg_Deckler
Community Champion
Community ChampionBecause 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