Filtering measure on dimension

Anonymous — Tue, 11 Sep 2018 15:08:49 GMT

Hi everyone,

I've been searching a lot but didn't find anything that would work.

So I'm asked to provide a map that displays the bubbles in red where the parameter is < 0.2.

My measure table contains the results of all the parameters.

I'm having a dimension table that contains all the parameters.

My problem is that the map takes into account the results of all the parameters and gives a false overview.

I tried something like this in my measure =Min({<Parameter.Nom='*ParameterName*'>}Result) but it's not working.

So how can I filter the measure based on my dimension?

Any idea would be greatly appreciated!

Thanks,

Re: Filtering measure on dimension

Anonymous — Tue, 11 Sep 2018 16:26:31 GMT

I was finally able to get it working by doing this:

My measure on the map looks like that

=min({<[ParameterName]={"Parameter"}>}[Result])

Then always on the map under appearance -> Colors and legend I selected By expression and:

=if(min({<[ParameterName]={"Parameter"}>}[Result]) <= 0.2, Red(), Green())

Now the display is correct.

Now I may ask another question is it possible to open this app with the results of the latest date displayed?

Thanks,