Forum Discussion
Solved
Total count for specified date
Itemnumber. Date. Status 1. 3/15/2025. Notstarted 2. 3/14/2025. Notstarted 3. 3/14/2025. Completed Expec...
Hi bzeeblitz,
Please create the following measures:
Count Item Number = COUNT('Table'[ItemNumber])Count Not Started = IF(ISBLANK(CALCULATE([Count Item Number], 'Table'[Status] = "Notstarted")), 0, CALCULATE([Count Item Number], 'Table'[Status] = "Notstarted"))Count Completed = IF(ISBLANK(CALCULATE([Count Item Number], 'Table'[Status] = "Completed")), 0, CALCULATE([Count Item Number], 'Table'[Status] = "Completed"))Then insert them in a table:You can order your table by Date Desc
If my answer fullfil your question, plase flag it as solution
Hi bzeeblitz please check this
NotStartedCount =
CALCULATE(
COUNT(TaskTable[ItemNumber]),
TaskTable[Status] = "Notstarted"
)
CompletedCount =
CALCULATE(
COUNT(TaskTable[ItemNumber]),
TaskTable[Status] = "Completed"
)
But we need to group by date for those status column
List1
Itemnumber date
List2
Itemnumber date status
So the measure you given that shows count of status but not the date wise count of status
