Forum Discussion
Solved
Suppressing the second minimum value in a column
Greetings, I am working with data that requires all values under 50 be suppressed AND if there is only one value under 50 in a column that the next lowest is also suppressed. (see examples). Rank...
Rank = RANKX(allselected('Table'),calculate(sum('Table'[Total Count])),,ASC) Show = if([Rank]>2 || [Rank]=2 && minx(ALLSELECTED('Table'),[Total Count])>=50,1,0)Thank you! That works great!
If the total count is a range, would it be this?
Show = if([Rank] > 2 || [Rank] = 2 && minx(ALLSELECTED('Table'), [Total Count]) > 1) && minx(ALLSELECTED('Table'), [Total Count]) <= 10, 1, 0)
Thank you again
That's the part I'm having issues with too.
IF([_Total Count] <= 50, "**", [_Total Count] ) only suppresses values 50 and under
IF([_Total Count] <= 50 && [_Rankx] = 2, "**", [_Total Count]) doesn't work
I also tried
var _min = IF([_Total Count] <= 50, 1, 2)
var _secMin = if([_rankx] = 2, 1, 2)
return
SWITCH(
TRUE(),
_min = 1 && _secmin = 1, "**",
[_Total Count]
)
doesn't work either.
Rank = RANKX(allselected('Table'),calculate(sum('Table'[Total Count])),,ASC)
Show = if([Rank]>2 || [Rank]=2 && minx(ALLSELECTED('Table'),[Total Count])>=50,1,0)Thank you! That works great!
If the total count is a range, would it be this?
Show = if([Rank] > 2 || [Rank] = 2 && minx(ALLSELECTED('Table'), [Total Count]) > 1) && minx(ALLSELECTED('Table'), [Total Count]) <= 10, 1, 0)
Thank you again