Forum Discussion

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

DAX calculation

From a single Fact table I have created two measures from two different column , one is "Total Staff Attendance"=Distinctcount(Table1[Name&Date]),  another measure is "NewDC"=Average(Table1[TotalDesk...
Need Help
Show and Tell
Tips and Tricks
arif_tsrm's avatar
arif_tsrm
Icon for Helper I rankHelper I
2 years ago

thank you for your information, but in my data model( snowflake model) have a dimension table with monthly data , please see my data model

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Share the download link of the PBI file.

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

    it is fully confidential data, so without shearing have others option please?