Measure for subtraction of values from the same column

[sraj]

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?

[richbenmintz]

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]

[sraj]

@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.

[richbenmintz · Accepted 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]

[sraj]

@richbenmintz  Thank you!!

[richbenmintz]

@sraj,

No Problem, happy to help

[sraj]

@richbenmintz ok, will that....what does "foo" in your measure mean?

[richbenmintz]

Hi @sraj,

just a place holder, i do not know the actual column name you are trying to sum.

[amitchandak]

@sraj , You need to create measure for that, with those filter inside the measure

[sraj]

@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.