Retrieve minimum value from multiple measures

DAX DAX Calculations
1

Hi all,

I hope this is not too complicated, I have three measures that extract minimum value from two dates. See image #1 for the associated Dax formula. It is the same for all three measures. I want a third measure that calculates the minimum value of the three measures excluding negative values. See image #2.

Image #1
![image|320x500](upload://7iD10

Image #2
image

I know that I can do Switch statement but wanted to know if there is a more efficient way to write the measure without having to do a long nested Switch statement.

Thank you in advance.
WIP File.pbix (18.1 MB)

2

Hi @ysherriff,

Give something like this a go:

Minimum Value greather than zero =
MINX(
    FILTER(
        { [Email Signup Date RFP Influence Time], [Event Signup Date RFP Influence Time], [Form Signup Date RFP Influence Time] },
        [Value] >= 0
    ),  [Value]
)

I hope this is helpful

3 Likes
3

Perfect and thanks Melissa. Will make sure to save this in Analyst Hub Documentation.

:smile:

I have one quick question. Not imperative but curious from your perspective. Do you think it is best to make one long measure rather than having 4 separate measures? Or the way it is structured is efficient?

Thanks for your insight.

4

Hi @ysherriff,

If performance isn’t an issue. I don’t think it matters… But I’m by no means an optimization expert so if there are concerns you might want to create a new topic in the Optimization lab category and invite the maestro AntrikshSharma.