Measure with filter select

Question

Hi All,&nbsp;Could you please help me create a new measures which has filter in that&nbsp;&nbsp;example - a , b and c&nbsp;&nbsp;i want in measures only a&nbsp;

anonymous · Answer

i want to create a formula where&nbsp;&nbsp;&nbsp;exp-&nbsp;these are two column measures electronic, spend&nbsp;&nbsp;in electronic - Mobile, Tv&nbsp; and AC&nbsp;in formula i want - to create new measure --&nbsp;spend * filter electronic- mobile in formula&nbsp;&nbsp;could you please help&nbsp;&nbsp;thanks ...

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
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
&nbsp;
Best Regards,
Lin

anonymous · Answer

Hi&nbsp;v-lili6-msft&nbsp;,&nbsp;No these is not solutions for these measures&nbsp;I have one measures and one dimension i want to make a formula with them&nbsp;&nbsp;Example -1. Category&nbsp; --furniture , table and chair2. Spend money - 50000&nbsp;i want one measure with combine them and filter in that particular category&nbsp;example -&nbsp;&nbsp;spend money * category(chair) only&nbsp;&nbsp;create that formula which shows these one '&nbsp;please kindly help me on these.&nbsp;thanks .&nbsp;&nbsp;&nbsp;

Forum Discussion

Measure with filter select

3 Replies

Related content

DAX Measure ignore filter/slicer selection

Dynamic measure filtering

Filter by Rank measure

Calculate measure based on Filter selection

Select a measure based on a filter selection