Forum Discussion
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...
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.
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)
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.
thank you for your information, but in my data model( snowflake model) have a dimension table with monthly data , please see my data model
