Re: Measure by Slicer Selection

Dgreen23 · ‎04-23-2020

I need a measure that does a calculation based on a slicer selection. Does anyone know how to do this?

V-lianl-msft · ‎04-23-2020

Please refer to this blog. It should meet your needs:https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

If the problem persists,please describe more details to let us know more about your scenario.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k · ‎04-23-2020

@Dgreen23 can you provide more context on what you are trying to achieve. Read this post to get your answer quickly.

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Dgreen23 · ‎04-23-2020

@parry2k,

Attached is a visual I doodled up on the fly. I have a slicer that changes the data shown on this dashboard based on one of 3 companies to select from. I want to make measures that will change what is represented for the sales goal and sales pace line if all companies are selected.