Forum Discussion
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-msftCommunity 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