Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |