Forum Discussion
Help me for the DAX
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/8jb1mkm8eev559...
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,
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
Community Support
Community SupportHi 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,