Make a measure into a dynamic dimension and filter/bookmark

[DiegoF]

Hi developers,

I have a measure or a condition that has some operations in it, and I need it to be a dimension. For example, this is the formula: 

If(RangeSum(Above(Count(Terminal), 0, RowNo())) <= count(total Terminal)*0.8, Green(), Yellow())

This condition I use it to change the color of a dimension, but also as a measure that indicates me which puts an X in the measures with the dimension it takes, something like this:

As you can see, I have the users marked with X up until the 80% of the total. I want to have as a dimension this condition, so it only shows me up to the 80%. I also want it dynamiclly because if I filter by date, the ranking changes so the n of users change as well, and want it to save it as a bookmark that when i filter a date and apply the bookmark, it shows me the 80% of users each time different (accordingly to the date).

How can I do this?

Thanks!

[Gabbar]

You need a relative dimension to make the measure selective.
Lets Suppose in this case that Dimension is 'Users' and your measure is 'M1'
Then in table in Dimension type   :-  Aggr(M1,Users).
Now this will work as Dimension and you will be able to select from the values of M1, you will see values of M1.

But the other part is that you will not be selecting M1, you will be selecting Users and you would be able to see that in selection which comes above dashboard. 
Due to this the downside is you will be forced to select this filter as your last filter, and also it would be very slow as first it would be calculating the measure and then the respective dimension of users.

[vincent_ardiet_]

If you add your condition in the "Acum. %" expression, all measures will be NULL after your threshold and the matching dimension should disappear