Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.