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
Then please feel free to review my prevuous comment
Thanks,but when I click the each status I would need to the Item number that's is not started,Completed So on from list2,kindly suggest.