Greetings All,
Just trying to create a minimum value greater than zero across three calculated numerics [a], [d], and [c].
I used
minimum (currentMeasure within set [a], [d], [c])
The report validated - but I have empties on the Query Calculation I inserted.
Obviously I did something wrong - just trying to get the syntax down.
I appreciate all the views and replies in advance.
Cheers
How about using a filter() function within the espression to exclude the members with zero measure values?
MF.