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

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

Then please feel free to review my prevuous comment

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

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.