cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jturdanes Occasional Visitor
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.

 

Please help.

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
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

5.PNG

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.

6.PNG 

Regards,

Jimmy Tao

1 REPLY 1
Community Support Team
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

5.PNG

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.

6.PNG 

Regards,

Jimmy Tao

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

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.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 297 members 3,188 guests
Please welcome our newest community members: