Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Than need to filter values in TableA as shown below .
Please let me know the process to achieve the result .
Thanking you in advance .
Regards,
Srinivas.
Solved! Go to Solution.
Hi @SrinivasaRao5_ ,
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.
Hi @SrinivasaRao5_ ,
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.
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.
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.
Hi @SrinivasaRao5_ ,
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.
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.
Hi ,
Please suggest me the solution.
Regards,
Srinivas.
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.
Help when you know. Ask when you don't!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |