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.
Need to find the MEETINGS LEFT number, please advise.
I had to filter INPROGRESS as below to get the count
‘Q’ & ‘R’ = IN PROGRESS
Same with Checked IN to get the count
I & F = CHECKED IN
Now I need the MEETINGS LEFT which is the subtraction between INPROGRESS & CHECKED IN…this makes me feel like I have to create a new measure for the MEETINGS left also for Today, I have a hearing date available to filter that. Can someone please advise on this?
Solved! Go to Solution.
Hi @sraj,
Ah you want to count the rows
In Progress = Calculate(countrows('table'), 'table'[queue_cat] in {"Q","R"})
Checked In = Calculate(countrows('table'), 'table'[queue_cat] in {"I","F"})
Meetings Left = [In Progress] - [Checked In]
Proud to be a Super User!
Hi @sraj
I would probably create three measures:
In Progress = Calculate(sum('table'[foo]), 'table'[queue_cat] in {"Q","R"})
Checked In = Calculate(sum('table'[foo]), 'table'[queue_cat] in {"I","F"})
Meetings Left = [In Progress] - [Checked In]
Proud to be a Super User!
@richbenmintz - may be I didnt ask the right question...the Q,I,R,F 'queue_cat' exists on this same column called 'queue_cat'. So all I have is one column not two different ones. I hope this makes sense, please advise.
Hi @sraj,
Ah you want to count the rows
In Progress = Calculate(countrows('table'), 'table'[queue_cat] in {"Q","R"})
Checked In = Calculate(countrows('table'), 'table'[queue_cat] in {"I","F"})
Meetings Left = [In Progress] - [Checked In]
Proud to be a Super User!
No Problem, happy to help
Proud to be a Super User!
Hi @sraj,
just a place holder, i do not know the actual column name you are trying to sum.
Proud to be a Super User!
@sraj , You need to create measure for that, with those filter inside the measure
@amitchandak I understand, need help to create a new measure as the Q, I, R, F all exists on the same column called queue_cat. I am new to this and never done it before, can you please help.
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.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |