Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |