Forum Discussion
Total count for specified date
Itemnumber. Date. Status
1. 3/15/2025. Notstarted
2. 3/14/2025. Notstarted
3. 3/14/2025. Completed
Expected output
I need to build table visuals in the below manner based on date
Date. Itemnumber. Notstarted Completed
3/15/2025. 1. 1. 0
3/14/2015. 2. 1. 0
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
10 Replies
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
why we don't display itemnumber 3 ?
Hey ryan_mayu, I think he wants them grouped by Date and count them.
At least this is how I interpreted it.
Yes I want to group by date from two different lists and then show report
List1
Date. Itemnumber
List2
Date itemnumber. Status
So when I group by date then I need to show below columns
Final result
Date itemnumber status
We can display I just showed sample data that's it, however we got to show the entire data
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
