The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |