Forum Discussion
Search Filter For Hierarchy
HI All, I have been playing out with how to figure out how to do a contains filter for two tables that I am unable to join due to the lack of data for some of the values. In on table I have: ...
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Flag = var _select=SELECTCOLUMNS('Table',"1",[Project ID] var _select1= SELECTCOLUMNS(FILTER(ALL('Table'),'master table'[Project ID] in _select&&'Table'[Project ID]=EARLIER('master table'[Project ID])),"2",[Workstream ID]) return IF( 'master table'[Project ID] in _select && BLANK() in _select1 ,"Blank","Found")2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Flag =
var _select=SELECTCOLUMNS('Table',"1",[Project ID]
var _select1=
SELECTCOLUMNS(FILTER(ALL('Table'),'master table'[Project ID] in _select&&'Table'[Project ID]=EARLIER('master table'[Project ID])),"2",[Workstream ID])
return
IF(
'master table'[Project ID] in _select && BLANK() in _select1 ,"Blank","Found")2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly