Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Nesting multiple function in dax

I try to make the following measure:

lesson succes = DIVIDE(COUNTROWS((FILTER('Geanonimiseerde rapportage'; 'Geanonimiseerde rapportage'[Lesson Completion] = "completed"); FILTER('Geanonimiseerde rapportage'; 'Geanonimiseerde rapportage'[Lesson Success] = "passed")));1)
 
I have in 2 collum rows that can give a value if a lesson is completed or not. so I OR'ed them. But it seems that the countrows doesnt get a table value back now. What am I missing here?
3 REPLIES 3
Greg_Deckler
Super User
Super User

I think:

 

lesson succes = DIVIDE(COUNTROWS(FILTER('Geanonimiseerde rapportage'; 'Geanonimiseerde rapportage'[Lesson Completion] = "completed" || 'Geanonimiseerde rapportage'[Lesson Success] = "passed"));1)

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks so much, I didn't know you could also use l l in DAX. 

You could have also done OR( ... ) but it's way more convenient to use ||

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.