DAX - find lowest value of three variables over 0

[Anonymous]

Hi,

I have created three variables that do a calculation and return a single value. I now need to figure out which of these thress is the lowest but over 0.

Let's say I have:

var No1 = 2 

var No2 = 0

var No3 = 6

I want to declare a variable that returns No1 in the above case as it is the lowest value out of the three that is over 0.

I'll need this variable for a calculation later on in my code.

[Zubair_Muhammad]

@Anonymous 

Something like this ..May be

var No1 = 2 
var No2 = 0
var No3 = 6
VAR lowest=MINX(Filter({No1,No2,No3},[Value]>0),[Value])

[Anonymous]

What is [Value] refering to in this formula?

[Zubair_Muhammad]

@Anonymous 

When we create a table manually like { "a","b"}, the column name of the that table is "Value"

[Anonymous · Accepted solution]

I found a (very ugly) solution:

VAR lowestoverzerso =

MIN (

MIN ( IF ( No1 < 1, No2, No1), IF ( No2< 1, No1, No2 ) ),

IF (

No3 < 1,

MIN ( IF ( No1 < 1, No2, No1), IF ( No2< 1, No1, No2 ) ),

No3

)

)