cancel
Showing results for
Did you mean:
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

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 297 members 3,188 guests
Recent signins: