Measure with filter select

[Anonymous]

Hi All,

Could you please help me create a new measures which has filter in that 

example - a , b and c 

i want in measures only a 

[v-lili6-msft]

hi, @Anonymous 

You could use SWITCH to create a dynamic measure with slicer.

here is a similar post for you refer to:

https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-via-a-slicer/ba-p/87027

And if not your case, please share some sample data and your expected output.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

No these is not solutions for these measures

I have one measures and one dimension i want to make a formula with them 

Example -

1. Category  --furniture , table and chair

2. Spend money - 50000

i want one measure with combine them and filter in that particular category

example - 

spend money * category(chair) only 

create that formula which shows these one '

please kindly help me on these.

thanks .

[Anonymous]

i want to create a formula where 

exp-

these are two column measures electronic, spend 

in electronic - Mobile, Tv  and AC

in formula i want - to create new measure --

spend * filter electronic- mobile in formula 

could you please help 

thanks ...