This is going to be bit headache. Since we are having so many measure grouped under measure values shelf.
If I try to check the condition for Number of Beds it will get applied to all the measure not matter what data type it holds. This is possible but you will have to write the separate calculation for each of the parameter that you are trying to compare. I think it will be much much easier if you can use the approach where you assign one parameter to one sheet instead of putting everything together.
You can also achieve it using fake columns which is most commonly used method ppl use in this case. I am not follower of that method.
Let's wait till someone has good solution.
Actually I can achieve that by creating separate sheet/ axis. However I need to avoid that.
I need to show this at place sheet only as there are so many such measures on the real file which I am working with. So that would impact the dashboard load too.
That certainly helps, however as per my requirement these districts are coming from 3 different filters. And I have to provide these 3 filter selection and I can't just have one.
Moreover I also need to create a calculated field as below which is missing in this result.
Above/meet target is in green
Below Target is red.