Forum Discussion
ShivGC
2 years agoHelper I
Multiple Select option
Hi I couldn't quite find the answer to my question online so I decided to drop the question on the forums myself. I have two tables that have no relationship Client (Distinct) Table: ...
- Anonymous2 years ago
Hi ShivGC ,
Please try to create a measure with below dax formula:
Measure = VAR _a = SELECTEDVALUE ( 'Client Information'[Client ] ) VAR tmp = SELECTCOLUMNS ( Client, "Client Name", [Client] ) VAR _str = CONCATENATEX ( tmp, [Client Name], "," ) VAR _result = IF ( CONTAINSSTRING ( _str, _a ), "#006D9E", "#A6E2EF" ) RETURN _resultAdd a scatter visual with Client Information table, and set the markers color
 
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - 2 years ago
IsTable1InTable2 = IF( COUNTROWS( FILTER( 'Table1', 'Table1'[ColumnName] IN VALUES('Table2'[ColumnName]) ) ) > 0, TRUE, FALSE )
Here is a code that worked for me 🙂
lbendlin
2 years agoSuper User
You may want to look at the "Decomposition tree" visual. It can give you these answers much faster.