Help me for the DAX

[Anonymous]

Hi, Please help me find the DAX to measure the Number of class taken attendance and Number of class not taken attendance. I have attached the pain in this link https://www.dropbox.com/s/8jb1mkm8eev559y/My%20Data.pbix?dl=0 Thanks

[nandukrishnavs]

@Anonymous 

absent = CALCULATE(COUNT('Attendance Master'[Child ID]),'Attendance Master'[Child Is Present?]=FALSE())

Present = CALCULATE(COUNT('Attendance Master'[Child ID]),'Attendance Master'[Child Is Present?]=TRUE())

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂 

[Anonymous]

Thank you for help bro. But, I want to know how many class taken attendance and how many class do not taken attendance in a month

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can try to use the following measures to meet your requirement:

class taken attendance = COUNTROWS(FILTER(SUMMARIZE('Class Master','Class Master'[Class ID],"Attendance",COUNTROWS('Attendance Master')>0),[Attendance]))

class do not taken attendance = 
COUNTROWS(FILTER(SUMMARIZE('Class Master','Class Master'[Class ID],"Attendance",COUNTROWS('Attendance Master')>0),not [Attendance]))

If it doesn't meet your requirement, Could you please show the exact expected result based on the tables that you have shared?

By the way, PBIX file as attached.

Best regards,

[nandukrishnavs]

@Anonymous  Use merge option in Edit Query.

Class ID in Attendance Master and Class ID in Class table. (All from the class table and matching from the attendance table. )

Then count the blanks in the new class id column. That is the count of classes has not taken attendance.