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.
I have a table called 'Filtered Items' which is a duplicate of a table called 'Items'.
I've created a slicer containing 'Filtered Items'[Name] and a table card containing 'Items'[Name].
The behavior I am trying to create is to remove any items in the table containing 'Items'[Name] where 'Items'[Name] can be found in the selected values of the slicer containing 'Filtered Items'[Name].
Here is what I've tried so far but is not working:
COUNTROWS(
CALCULATETABLE(
ALLSELECTED('Filtered Items'),
USERELATIONSHIP(Items[ILC], 'Filtered Items'[ILC])
)
) > 0
Solved! Go to Solution.
Hi @Anonymous
I'm not sure I completely understand what you are aiming for but let's try this:
1. Place a matrix visual in your report with 'Items'[Name] in rows
2. Create a measure to determine what items will be shown:
ShowMeasure = IF ( NOT ( SELECTEDVALUE ( 'Items'[Name] ) IN VALUES ( 'Filtered Items'[Name] ) ), 1 )
3. Place the measure in the visual level filters of the matrix visual and select to 'Show items when the value:'--> is 1
By doing that, you will filter out the names that are not selected in the slicer
Hi @Anonymous
I'm not sure I completely understand what you are aiming for but let's try this:
1. Place a matrix visual in your report with 'Items'[Name] in rows
2. Create a measure to determine what items will be shown:
ShowMeasure = IF ( NOT ( SELECTEDVALUE ( 'Items'[Name] ) IN VALUES ( 'Filtered Items'[Name] ) ), 1 )
3. Place the measure in the visual level filters of the matrix visual and select to 'Show items when the value:'--> is 1
By doing that, you will filter out the names that are not selected in the slicer
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |