Total count for specified date

[bzeeblitz]

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

[techies]

Hi @bzeeblitz please check this

NotStartedCount =
CALCULATE(
COUNT(TaskTable[ItemNumber]),
TaskTable[Status] = "Notstarted"
)

CompletedCount =
CALCULATE(
COUNT(TaskTable[ItemNumber]),
TaskTable[Status] = "Completed"
)

[bzeeblitz]

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

[ryan_mayu]

why we don't display itemnumber 3 ? 

[bzeeblitz]

We can display I just showed sample data that's it, however we got to show the entire data

[MattiaFratello]

Hey @ryan_mayu, I think he wants them grouped by Date and count them.

At least this is how I interpreted it. 

[bzeeblitz]

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

[MattiaFratello]

Then please feel free to review my prevuous comment

[bzeeblitz]

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. 

[bzeeblitz]

Ok I would test and let you know

[MattiaFratello · Accepted solution]

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