Filter from a specific line in the measure

[sraj]

Hi everyone,

Need help, this measure that I have needs to include a filter, but I want that just for the last line “real_prj_held_cnt_i” to filter from this column 'status mrkt'[sch_state] IN { "I" } , { "F" }, { "U" }

How can I add it to this measure?

Measure

Settled Count =

 CALCULATE(MAX('status mrkt'[rp_protest_cnt])

 - MAX('status mrkt'[rp_bad_protest_cnt])

 - MAX('status mrkt'[real_held_cnt])

 - MAX('status mrkt'[real_prj_held_cnt_i] ) )

[lbendlin · Accepted solution]

Settled Count =
var a = MAX('status mrkt'[rp_protest_cnt])
 - MAX('status mrkt'[rp_bad_protest_cnt])
 - MAX('status mrkt'[real_held_cnt])
var b = if('status mrkt'[sch_state] IN {"I","F","U"},MAX('status mrkt'[real_prj_held_cnt_i],0)
return a-b