Count Ticket depending on Status

[milomilo2020]

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

[v-easonf-msft]

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