Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |