Forum Discussion

adumith's avatar
adumith
Helper I
3 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • adumith's avatar
    adumith
    3 years ago

    Thank you for your reply.

     

    However, it's returning this error:

     

     

adumith's avatar
adumith
Helper I
3 years ago

Hello everyone, 

 

I have tried other options but unfornately I don't get it....

 

TopRequestersPerCategory = 
    SUMMARIZE(
        ADDCOLUMNS(
            zendesk,
            "TotalTickets", 1
        ),
        zendesk[Requester],
        zendesk[Category],
        "TotalTickets", SUM(zendesk[TotalTickets])
    )

 

 

 

TopRequestersPerCategory =
    ADDCOLUMNS(
        SUMMARIZE(
            zendesk,
            zendesk[Requester],
            zendesk[Category],
            "TotalTickets", COUNTROWS(zendesk)
        ),
        "Rank", RANKX(
            FILTER(
                ALL(zendesk),
                zendesk[Requester] = EARLIER(zendesk[Requester])
            ),
            [TotalTickets],
            ,
            DESC
        )
    )

 

 

 

Any ideas?

 

My goal is be able to determinate a list of the requesters and the categories in which they have the most tickets? In other words, the formula should search for each applicant which categories have the most tickets and how many tickets.

 

Thank you in advance, 

 

 

 

  • adumith's avatar
    adumith
    Helper I
    3 years ago

    Ok folks,

    I'm still investigating.

    I found a tool called DAX Studio, where I can test the formulas and then if it does what I expect then I copy it to Power BI.

    Well, it turns out that the formula in the tool works but not in Power BI, so I am definitely doing something wrong.

    I have checked the table, the data structure, the column names and everything is fine.

    Otherwise the formula would not work in DAX Studio.

    DAX Studio

    Power BI

     

    Why?

     

    What I'm doing wrong?

     

    Thank you guys and sorry for be anoying.