cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
naitik_shah
Frequent Visitor

Measure with filter select

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 

3 REPLIES 3
Highlighted
naitik_shah
Frequent Visitor

Re: Measure with filter select

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 ...

Community Support
Community Support

Re: Measure with filter select

hi, @naitik_shah 

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-v...

3.JPG

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
naitik_shah
Frequent Visitor

Re: Measure with filter select

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 .

 

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors