If you want to sort horizontally by the value of the frequency. You can create a calculated field that it takes into consideration only "Implemented" and use that measure for sorting only.
Also, if you want the "implemented" to be shown on the left side you can just reverse the axis.
I see that the questions are already sorted descending by this frequency. How have you done that by now? Manually?
Yes manually, but I'd like to add a country filter on the side but it get distorted when I change the country.
I thought of a calculated field but I can't write it properly. Any idea?
try something like:
and after you have the number you can sort the Question using this field.
I get a "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions"...
try with some values
this should work
IT WORKS! Thank you!