topic Re: Filter with measures like values. Select a measure in App Development

Filter with measures like values. Select a measure

Anonymous — Wed, 18 Apr 2018 16:30:43 GMT

Hello.

I would like create a filter where I could choose between several measures, with the end to show in a pivot table or chart only a measure or other.

In this moment, I have this:

In this table, to different of a dimensions, the measures (Medidas) can not be selected. So always "Pasajeros" and "Pasajeros-km" are showed.

I can't want unpivot the table. So that isn't a option.

Is posible create a table with the measures and link with actual table?

Can someone help me?

Thanks and regards.

Re: Filter with measures like values. Select a measure

Gysbert_Wassenaar — Wed, 18 Apr 2018 17:06:34 GMT

Yes, you can add an extra table in your script with the expressions:

Measures:

LOAD * INLINE [

Label, Expression

Sum of Sales, sum(Sales)

Average Sales, avg(Sales)

];

After reloading you can add a filter pane in your app for the Label field. And change the measure in your pivot table with =$(=Only(Expression)) as expression and =Only(Label) as the label

Re: Filter with measures like values. Select a measure

Anonymous — Thu, 19 Apr 2018 08:30:58 GMT

Hello.

Thanks by your answer. But It don't work like I hope. Now when I choose one option, this is duplicate (obvious), and when I choose 2 or more, nothing.

The label isn't changed.

And

Is posible have the both columns (or any), and one of them hide/show when I choose a mesaure? Like when you select a opcion in a filter by dimension.

Thank you and regards.

Re: Filter with measures like values. Select a measure

MHarrell — Mon, 20 Jan 2020 19:58:00 GMT

Hi Gysbert,

This was very helpful for something I'm working on. Is there any way to set this up to where a user could select multiple labels and it would sum all of them rather than it only working when one is selected? My example would be that a user would be looking to combine certain types of cost like pharmacy cost, non pharmacy supply cost, salaries etc.?

Thanks for your help!

Matt