Monthly line chart calculation

[arif_tsrm]

I have two fact table( FactDeskCapacity, FactStaffAttendance) connected with Dim Calender Table using key MonthName,
Have two measure "Desk Capacity" is count of Desk from FactDeskCapacity, and "Total Staff Attendance" is DistinctCount of Date from FactStaffAttendance, please see the picture, now I want to show in a monthly line chart, in a month how many days "Total Staff Attendance" is greater than "Desk Capacity", for example the result will be 2 for february ( 7 , 9 th February)

[Uzi2019]

Hi @arif_tsrm 

please create the follwoing measure
Count day= CALCULATE( COUNT(date), FILTER('Table',[measure1]>[measure2]))


If I answered your question please give kudos and accept it as a solution!

[arif_tsrm]

Thank you for you reply, I have using your  above measure but not working , please see my below measure

test = var tst=CALCULATE(COUNT(FactStaffAttendance[DateOnly]),FILTER(FactStaffAttendance, [Total Staff Attendance]>[Desk Capacity]))

return tst

[Uzi2019]

Hi @arif_tsrm 
can you share screen shot what error /answer you are getting??

[arif_tsrm]

please see the screenshort, nothing is returning

[Uzi2019]

Hi @arif_tsrm 
I have to check the realtionship between all tables. why data is not flowing?
where you have craeted that measure??
you have 3 tables right?

can you share the data modeling ?
like pbix file on googe drive

[arif_tsrm]

Yes, only three table is used, please see the picture, data is secure for this reason I am not able to share the model.  here FactStaffAttendance is FactAccessControl and Total Desk is FactDeskCapacity.