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
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