PathContains from SelectedValue issue with GUID
I have a Table of equipment records that are connected through the Account to Regions. When I attempt to use the PATHCONTAINS() with SELECTEDVALUE() It always returns False() where if I hard code the GUID it works as expected. I created a seperate table of Regions to bypass any relationship filtering that may occur. HeirarchyRegionInPath = VAR SelectedRegion = "c4be4e26-d198-ec11-b3fe-000d3a09e9da" VS regionselected = SELECTEDVALUE('Region list'[Region]) VAR RelatedRegionPath = LOOKUPVALUE( ESI_region[HierarchyPath], esi_region[Region], RELATED(account[esi_territory]) ) RETURN IF( NOT(ISBLANK(SelectedRegion)) && PATHCONTAINS(RelatedRegionPath, SelectedRegion), TRUE(), FALSE() ) I must be missing something, all formats are text, tried Column VS measure and only measure would populate RegionSelected Tried CONTAINSSTRING() rather then PATHCONTAINS(), same result. Any help appreciated.
