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 Team ,

 

Please help me in this .i am able to filter the rows as shaown above , but i am trying to show the filtered affected rows count in the card visualization but its showing overall count only not changing the as per the filter .

 

Regards,

Srinivas.

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Try this:

Count = COUNTAX ( FILTER ( TableA, TableA[Name] = [Name Measure] ), 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.