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

 

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

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

10 Replies

  • MattiaFratello's avatar
    MattiaFratello
    Icon for Super User rankSuper User
    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

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

      At least this is how I interpreted it. 

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

        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

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

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

  • 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