Forum Discussion
arif_tsrm
Helper I
Helper IMonthly line chart calculation
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 "Tot...
arif_tsrmHelper I
Helper IThank 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
