Forum Discussion

bzeeblitz's avatar
bzeeblitz
Icon for Helper IV rankHelper IV
1 year ago
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...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MattiaFratello's avatar
    MattiaFratello
    1 year ago

    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

techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi bzeeblitz please check this

 

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

 

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

  • bzeeblitz's avatar
    bzeeblitz
    Icon for Helper IV rankHelper IV
    1 year ago

    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