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 
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

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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's avatar
      arif_tsrm
      Icon for Helper I rankHelper I
      2 years ago

      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.