Solved: Show the result of another value based on Slicer

Anonymous · ‎12-15-2018

Hi Experts

Is it possible to show the result of selection B if A is selected in the Slicer and and add the results of B to the measure that calcuates the result of selection A. with out B being selected.

When B is selected just show the result of B only.

parry2k · ‎12-15-2018

@Anonymous your question is not very clear

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.

View solution in original post

parry2k · ‎12-15-2018

@Anonymous your question is not very clear

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.

Anonymous · ‎12-16-2018

Hi Parry2k. firstly sorry for the poorly worded question, but i worked out the solution as follows:

ID (EMEA) vAOP$ 2 = CALCULATE(
            [$NSvPY4% (NOE @ AOP Rate)], FILTER(
                    'Product','Product'[Product Franchise]="Infusion Devices"),all(Management),Management[Level4]="EMEA (Euro Mideast Africa

Show the result of another value based on Slicer

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly