Forum Discussion

jturdanes's avatar
jturdanes
New Member
8 years ago
Solved

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...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

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