Forum Discussion
Solved
Identifying user tickets
Hello everyone, I have a table called "zendesk" which contains user tickets. Each one has a category assigned to it. I need to identify the requesters with the most tickets per category. I h...
Thank you for your reply.
However, it's returning this error:
Hello!
VAR TABLE =
TOPN(
1,
SUMMARIZE(
zendesk,
zendesk[Requester],
zendesk[Category],
"TotalRequirements", COUNTROWS(zendesk)
),
[TotalRequirements],
DESC
DESC
)
RETURN
MAXX(TABLE, zendesk[Requester])
Only the SUMMARIZE dont give you the results, you need something to return the "TOPN"
Put this Measure in a table with "Category"
Only the SUMMARIZE dont give you the results, you need something to return the "TOPN"
Put this Measure in a table with "Category"
Thank you for your reply.
However, it's returning this error:
Hello!
Looks like its missing the name of the measure,
"VAR TABLE =" is a Dax Function
It cant recognize "RETURN" because cant recognize "VAR"
This is shameful, a thousand apologies. 🙄
Rookie mistake. 😝
It's working smoothly.
Thank you so much.