Forum Discussion
How to show total number of queue items based on queue name
- 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
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