Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count of items by date on Line Chart

I have a list of items with a history and I want to get a count of specific type of item (bug) for each date and status to show a trend   This query works great to sum up  all my items Dev Complet...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Anonymous,

    You can try to use the following measure formula if it helps:

    TotalBugCountByDate =
CALCULATE (
    COUNT ( AllWorkItems[Work Item Type] ),
    FILTER (
        ALLSELECTED ( AllWorkItems ),
        AllWorkItems[Date] <= MAX ( AllWorkItems[Date] )
            && AllWorkItems[State]
            IN {
            "New",
            "Resolved",
            "Fixed",
            "Fix_Pending",
            "CLOSED",
            "Open",
            "Verification_Pending"
        }
            && AllWorkItems[Work Item Type] = "Bug"
    ),
    VALUES ( AllWorkItems[Date] ),
    VALUES ( AllWorkItems[State] )
)

    If the above also not hlep, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

You can do something like

=
CALCULATE (
    SUM ( table[value] ),
    ALLEXCEPT ( table, table[column1], table[column2] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    my table has a lot of colums and I am not looking for a sum..  I am I just want a count.   of the items by a specific type

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI Anonymous,

      You can try to use the following measure formula if it helps:

      TotalBugCountByDate =
CALCULATE (
    COUNT ( AllWorkItems[Work Item Type] ),
    FILTER (
        ALLSELECTED ( AllWorkItems ),
        AllWorkItems[Date] <= MAX ( AllWorkItems[Date] )
            && AllWorkItems[State]
            IN {
            "New",
            "Resolved",
            "Fixed",
            "Fix_Pending",
            "CLOSED",
            "Open",
            "Verification_Pending"
        }
            && AllWorkItems[Work Item Type] = "Bug"
    ),
    VALUES ( AllWorkItems[Date] ),
    VALUES ( AllWorkItems[State] )
)

      If the above also not hlep, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

      How to Get Your Question Answered Quickly  

      Regards,

      Xiaoxin Sheng