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.
Hi!
I'm so grateful for the help that has been provided to me on this forum. I was wondering if someone had some thoughts about one more issue I've come across.
I've been using a calculated measure to represent responses. The measure essentially counts the number of people who indicated a certain response (for example, a certain type of disability or health condition) UNLESS less than 15 people (but more than 0) selected that response. In that case, the text "<15" would appear.
The measure I've been using:
Disability or Health Condition | Number of Responses |
Disability1 | <15 |
Disability2 | <15 |
Disability3 | <15 |
Disability4 | 26 |
Disability5 | 22 |
Disability6 | 0 |
I would like the table to appear as:
Disability or Health Condition | Number of Responses |
Disability4 | 26 |
Disability5 | 22 |
Disability1 | <15 |
Disability2 | <15 |
Disability3 | <15 |
Disability6 | 0 |
Any tips or suggestions would be so appreciated! Thanks in advance!
Solved! Go to Solution.
See attached. I revised the file you sent me.
The problem is you are trying to sort both strings and number fields.
I think the easiest way to do this would be to just add an intermediate column where you return the "actual" value for all responses (including the <15 ones), then sort based on that column, even though your user is going to use the calculated one with the <15 logic attached.
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
57 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |