Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] ) )
Solved! Go to 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
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