cancel
Showing results for
Did you mean:
jturdanes Occasional Visitor

How to show total number of queue items based on queue name

Hi There,

I've been trying to figure out how can I display total number of queue items based on on Queue Name.

I tried creating new column with the following value :

Total Number of Queue Item = CALCULATE(COUNTROWS('Queue Item'), 'Queue'[Name]="High Priority") + 0

But I don't get the actual data.

Is this the right formula for this?

I was basing it to the already available column for Case, Total Number Of Cases = COUNTROWS('Case') + 0 but I am not able to make it work for Queue items.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions Community Support Team

Re: How to show total number of queue items based on queue name

Hi jturdanes,

What the exact issue occurs when you create the calculated column? Would you please share some sample data and show desired results?

If the column [Item] and the column [Name] are in same table ‘Queue’, then you should modify you DAX formula like below:

Total Number of Queue Item = CALCULATE(COUNTROWS('Queue'), 'Queue'[Name]="High Priority") + 0 If there’re two tables ‘Queue’ and ‘Queue Item’ in your report, you should create a relationship between the two tables based on a key column and then use the same DAX formula. Regards,

Jimmy Tao Community Support Team

Re: How to show total number of queue items based on queue name

Hi jturdanes,

What the exact issue occurs when you create the calculated column? Would you please share some sample data and show desired results?

If the column [Item] and the column [Name] are in same table ‘Queue’, then you should modify you DAX formula like below:

Total Number of Queue Item = CALCULATE(COUNTROWS('Queue'), 'Queue'[Name]="High Priority") + 0 If there’re two tables ‘Queue’ and ‘Queue Item’ in your report, you should create a relationship between the two tables based on a key column and then use the same DAX formula. Regards,

Jimmy Tao

Announcements Top Kudoed Authors
Users Online
Currently online: 297 members 3,188 guests
Recent signins:
• Swamy3105 • MarkSL • nisuomi • royb1973 • antalford88 • j-harris • CAOP • jorgemur • kitterific • Grzesiek89 • GVDD • luciaf • dazbutler1 • asifs0862 