Forum Discussion

arif_tsrm's avatar
arif_tsrm
Helper 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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Assuming the Dates on the X-axis have been dragged from the Calendar Table, write this measure

=countrows(filter(values(calendar[Date]),[Total staff atendance]>[NewDC]))

Hoep this helps.

arif_tsrm's avatar
arif_tsrm
Helper I
2 years ago

Thank you for your reply, dates on the X-axis have been dragged from the fact table( calender table have no date column , only month column is availavle)

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    That is not how it should be.  In the Calendar Table, there should always be a Date column.  All Date fields such as year, month etc. should be created in this Calendar Table and to all visuals, date related fields should be dragged from the Calendar Table.

    • arif_tsrm's avatar
      arif_tsrm
      Helper 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
        Super User
        2 years ago

        Hi,

        Share the download link of the PBI file.