Forum Discussion
Fali324
Helper II
Helper IIFinding the minimum value which isn't 0
Hi, I am trying to create a measure where it comes back with the lowest value which isn't 0. If the dataset it 0,0,1,4,5,7,8, it should return 1 rather than 0. I have tried COALESCE funct...
pls try thjis
Syk
Resident Rockstar
Resident RockstarThe Coalesce function only gets you the first non-blank value. Since 0 is not blank, it will return 0.
You can try something like
First non-zero = calculate(MIN(table[column]),table[column]>0)