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.

kentyler's avatar
kentyler
Solution Sage
6 years ago

Live would be so much easier if you transform the first table before loading it into power bi

numberName
1a
1b
2b
2      c
3      a
4a
4      a
5  b
6 c

Then you would not need to write ANY DAX code, a regular slicer would work fine.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi kentyler  ,

     

    Thank you for your response , i had amount column in that table . as said  if i split the name ,  that time  amount will be repeat multiple times and it is huge data with many columns . please let me know any other approach .

     

    Thank you .

     

    Regards,

    Srinivas.