Forum Discussion

milomilo2020's avatar
milomilo2020
Frequent Visitor
4 years ago

Count Ticket depending on Status

Hey, thanks for the help.

I have this table:

 

one action_id can have multiple ds_action_sk. On the other hand, each ds_action_sk canhave multiple status .

I need to create a DAX measure in order to visualize the change of status by insertion_date:

 

So the first time action_id = 122331 appeared was on 2/1/2022 with status=Open (We have a 1 on the 2/1/2022 representing the count of action_id. Then it appears again on 4/1/2022 but it has the same status = Open ( Noticed in the table that we still have the count '1' on 4/1/2022, as there is only one action_id (122331 ) with status Open , it doesn't take into account the ds_action_sk )

BUT on 5/1/2022 the action_id = 122331  changes to Closed, then in the table we see that the status Open status now has 0 counts and the status Closed starts to have a 1 count.

 

Thanks for the help

 

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, milomilo2020 

    Not sure about your needs, are you trying to create a matrix table with date as column and status as row to count all tickets with status open?

     

    Best Regards,
    Community Support Team _ Eason