Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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). Rankx is unimportant unless I need it to complete the suppression.
I am working with one table, we will call it 'Reports'.
I've tried using SWITCH statements, variables, etc. I can get close but not both at the same time. I am using a standard table to display information.
Thank you for any assistance!
What I have
Group Total Count Rankx
A 10 5
B 107 3
C 103 4
D 342 2
E 3,984 1
What I need
Group Total Count Rankx
A ** 5
B 107 3
C ** 4
D 342 2
E 3,984 1
Solved! Go to Solution.
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
RANKX is important, but you need to use it the other way round. Sort ascending by value. Suppress Rank 1, and if Value 1 is less than 50 then suppress Rank 2 as well.
That's the part I'm having issues with too.
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
Sure, but why? What if the minx is 1 ?
If 0 has be marked 0 and the range is between 1 and 10. It's a weird ask. Thanks!
then you must use >=1 , not >1
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |