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!

 

 

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

    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's avatar
      Uzi2019
      Icon for Community Champion rankCommunity Champion
      2 years ago

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

       

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

        please see the screenshort, nothing is returning