Forum Discussion

arif_tsrm's avatar
arif_tsrm
Icon for Helper I rankHelper I
2 years ago

Monthly 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...
Need Help
Show and Tell
Tips and Tricks
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

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!