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

[jturdanes]

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.

[v-yuta-msft · Accepted solution]

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