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.
I want to force a zero to display instead of blank when a specific condition occurs.
I have a measure that calculates points Done, which works fine:
However, if the Sprint is less than the Current Sprint (is in the past) and it shows blank, I want it to return 0 instead. This is my attempt but it is showing zero for all Sprints and not just those in the past.
Solved! Go to Solution.
You can try
Effort done 2 =
var workDone = [Effort-Done]
return IF( SELECTEDVALUE( 'PI_Work'[Sprint#]) < [Current Sprint#], COALESCE(workDone, 0), workDone)
You can try
Effort done 2 =
var workDone = [Effort-Done]
return IF( SELECTEDVALUE( 'PI_Work'[Sprint#]) < [Current Sprint#], COALESCE(workDone, 0), workDone)
I get an error with that: “Too many arguments were passed to the SELECTEDVALUE function. The maximum argument count for the function is 2.”
Typo, I was missing a ). I've edited the original post.
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |