Forum Discussion
Creating a list without making a new table
Hi mvpeterman,
Based on my research, I am afraid you could not auto generate the GroupName list to filter for your data, I could not find any logic to filter the name, could you please offer me more information about your logic to filter the group names?
Regards,
Daniel He
Hello v-danhe-msft,
My logic to filter the group names was to look at the team of people to get the group name...That's where my problem is happening since I need the unassigned tickets along with the assigned tickets from the selected groups for that team.
When I realized that it was going to be hard to split groups up by people/teams I tried to hard code the groups into team groups, but Power BI gives me an error since there are too many arguments for an IF statement (one team has 75 groups).
I don't think there is a way that I can do it...My quick fix for now is that the head of our Zendesk is just going to notify me when he adds people to a group so that I can manually filter the report instead of automatically filtering the report like I wanted.
Thank you for trying to help :)
If I figure out a solution to my problem I will let you know!