Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
Looking for some help to see if this can be done. Conceptually, I need to filter a dimension table based on a selection on another dimension table. These two tables are unable to be linked together as one of relationships will be made inactive.
In the PBIX example attached, I want the Location slicer selection to filter the Salesperson slicer and show only the 5 salespersons that are in that location.
Solved! Go to Solution.
Thanks @Jihwan_Kim
That would be an acceptable solution if I am trying to find salespeople with sales, the slicer should show users filtered by location.
I found the solution in another post and I have updated the PBIX - Filtering a slicer example
DAX used
Location Filters Users =
IF (
MAX ( 'Salespeople'[Location] )
IN VALUES ( 'Sales Location'[SalesLocation] ),
1,
0
)
Hi,
Please check the below picture and the attached pbix file.
1. create a measure like below.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks @Jihwan_Kim
That would be an acceptable solution if I am trying to find salespeople with sales, the slicer should show users filtered by location.
I found the solution in another post and I have updated the PBIX - Filtering a slicer example
DAX used
Location Filters Users =
IF (
MAX ( 'Salespeople'[Location] )
IN VALUES ( 'Sales Location'[SalesLocation] ),
1,
0
)
Awesome, thanks a lot!
@DarrenLau check this video on my YouTube channel which talks about something similar. https://youtu.be/XXVRwvni4Ms
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
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.
Hi @parry2k ,
Thanks for the video link. I couldn't work out how to utilise the CROSSFILTER function in my example, but I found another post that had the correct solution.
@DarrenLau sounds good. Thanks for the update. Best!
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
109 | |
94 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |