Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello everyone,
I searched long and hard for an answer to my question. I did find some threads which were similar but did not find the exact same problem as mine.
My goal is to have a table with a column containing the ticket ID (primary ID) and all free fields as columns in a flat structure so I can do visualizations for our tickets in Zendesk. This can be seen in the sketch below.
Ticket ID | Free field 1 | Free field 2 | Free field 3
------------------------------------------------------
1 | x | true | 2
2 | y | true | 13
3 | x | true | 3
4 | x | true | 3
5 | y | false | 7
I imported our Zendesk data through the "get data" function and in the Ticket.table we have two columns. One contains the Ticket ID and another column contains the free field data. This is all good so far. However, the free field data is being imported as a list of records. If I then use the expand function, the table I want will be formatted as follows:
Ticket ID | Free field.title | Free field.value
----------------------------------------------
1 | Free field 1 | x
1 | Free field 2 | true
1 | Free field 3 | 2
2 | Free field 1 | y
2 | Free field 2 | true
2 | Free field 3 | 13
etc.
While this kind of works, I run into some troubles with my visualizations due to the fact that I want to count tickets which must meet multiple requirements (for example: count ticket where (Free field 1 = x) AND (free field 3 > 5)). When I do this, I always get the value 0. This makes sense because the ticket has no flat structure and therefore the multiple parameters cannot be used.
I would like to be able to fix this in the "edit query" instead of with DAX if this is possible, this will save me a lot of time with the many visualizations I have to make in the following months.
Please understand that I am a newbie, but not scared to put in some work to get it working. If my description is not fully clear, please let me know and I'll add it in the comments.
Could anyone please guide me in the right direction?
With kind regards,
Tim
Solved! Go to Solution.
Thank you so much. I tried this before, but made a mistake by aggregating.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
58 | |
40 | |
36 |
User | Count |
---|---|
84 | |
69 | |
59 | |
46 | |
46 |