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