Forum Discussion
Filter two unrelated table
Anonymous see the attached solution, it also takes care if no region or more than one region is selected. Tweak it as you see fit.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserAnonymous here is the updated measure to get Yes if Global is selected:
Yes/No =
VAR __selectedRegions = VALUES ( User[User Region] )
VAR __customRegion = CALCULATE ( COUNTROWS ( Customer ), INTERSECT ( VALUES ( Customer[Customer Region] ), __selectedRegions ) )
VAR __isGlobalSelected = MAXX ( FILTER ( __selectedRegions, [User Region] = "Global" ), [User Region] )
RETURN
IF ( NOT ISBLANK ( __customRegion ) || __isGlobalSelected = "Global", "Yes", "No" )
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡