Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
I want to choose one of the columns on the left table to get all the values in the right table that contain the same value.
As highlihgted in the picture, I want to get all the rows that contain 'Unemployment Insurance' on the right table.
Thanks s lot!
Solved! Go to Solution.
Hi @Anonymous
I notice that you want to create some measures in your another post,
Why do you need to create measures?
could tell me what's wrong you meet when you use the methods v-yulgu-msft provides?
With more details, i would give a more useful solution.
Best regards
Maggie
Hi @Anonymous
Assume "visit reason values" and "visit reason" are two columns in different tables.
add [ visit reason values] in the slicer, create measures
selected value = SELECTEDVALUE(Sheet3[values]) show = IF(NOT(ISERROR(FIND([selected value],MAX(Sheet4[reason])))),1,0)
add measure [show] in the visual level filter and show items when value is 1
Best Regards
Maggie
Thank you so much, it worked fine!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |