Matching records and filter the data

[Anonymous]

Hi ,

I have two tables as shown below .

TableA:

number        Name

1                       a,b

2                       b,c

3                       a

4                       a,c

5                       b

6                       c

TableB:

number        Name

1                       a

2                       b

3                      c

Requirement is i had two tables as shown above, i have a slicer value from table  tableB . for example if i select name value a from tableB it needs to be filter a contain values need to be filter in tableA. please let me know the process.

Example : i have selected Value A from TableB

TableB

Than need to filter values in TableA as shown below .

TableA

Please let me know the process to achieve the result .

Thanking you in  advance .

Regards,

Srinivas.

[Icey · Accepted solution]

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]

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]

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]

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]

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]

Hi ,

Please suggest me the solution.

Regards,

Srinivas.

[Anonymous]

Thank you  @Icey , its worked for me .

Regards,

Srinivas.

[kentyler]

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

number	Name
1	a
1	b
2	b
2	c
3	a
4	a
4	a
5	b
6	c

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

[Anonymous]

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.