Forum Discussion

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 ...

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.

Community Support

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
Not applicable
6 years ago
Thank you Icey , its worked for me .

Regards,
Srinivas.
Anonymous
Not applicable
6 years ago
Hi ,

Thank you so much for your kind help , after filter the records i need to show the count(number of rows affected in table A) in card visualization .could you please help me on this .

i was tried to showing the count but over all count only displaying in the visualization .filtered records rows count is not displaying.

Regards,
Srinivas.
- 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
    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.