Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matching records and filter the data

Hi ,   I have two tables as shown below .   TableA:   number        Name 1                       a,b 2                       b,c 3                       a 4                       a,c 5    ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Try this:

    Name Measure =
IF (
    SEARCH ( SELECTEDVALUE ( TableB[Name] ), MAX ( TableA[Name] ),, BLANK () )
        <> BLANK (),
    MAX ( TableA[Name] )
)

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Icey  ,
 
Thank you so much for your support , i am trying to select more than one value from slicer that its showing same constant vlaue in card visual. please suggest me the solution .
 
Regards,
Srinivas.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ,

 

Please suggest me the solution.

 

Regards,

Srinivas.