PathContains from SelectedValue issue with GUID

Hi Jp_ON - update the IF() logic in the HeirarchyRegionInPath measure

HeirarchyRegionInPath =
VAR SelectedRegion = SELECTEDVALUE('Region list'[Region], BLANK()) -- Use SELECTEDVALUE()
VAR RelatedRegionPath =
LOOKUPVALUE(
ESI_region[HierarchyPath],
esi_region[Region],
RELATED(account[esi_territory])
)
RETURN
IF (
NOT(ISBLANK(SelectedRegion)) &&
PATHCONTAINS(RelatedRegionPath, SelectedRegion),
TRUE(),
FALSE()
)

if the above is logic not working, can you revisiting the relationships between the tables to ensure that the lookup functions are pulling the correct data.

Hi Jp_ON ,

You can update the formula of measure [HeirarchyRegionInPath] as below, please check if it can return the expected result...

HeirarchyRegionInPath =
VAR SelectedRegion =
    SELECTEDVALUE ( 'Region list'[Region] )
VAR hpath =
    SELECTEDVALUE ( esi_region[HierarchyPath] )
RETURN
    IF (
        NOT ( ISBLANK ( SelectedRegion ) )
            && IFERROR ( SEARCH ( SelectedRegion, hpath, 1, 0 ), 0 ) > 0,
        TRUE (),
        FALSE ()
    )

If the above one can't help you figure out, please provide some raw data in your table 'account' (exclude sensitive data) with Text format and your expected result with backend logic and special examples base on provided raw data. Is there any relationship between the table 'esi_region' and 'account'? If yes, please provide the relationship info(cardinality, direction etc.). It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

Best Regards

Thank you for the response. Greatly appreciated. Unfortunately they did not get me to the outcome I'm after.

here is some Example "Region List"

And here is the Table of records we're looking to filter by the selected region.

Relationships are as follows.