Forum Discussion
arif_tsrm
Helper I
Helper IDAX 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...
Ashish_Mathur
Super User
Super UserHi,
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_tsrmThank 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
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
thank you for your information, but in my data model( snowflake model) have a dimension table with monthly data , please see my data model