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.
Hi,
I am trying to generate a dynamic table shows the inverted result of a slicer.
In order to obtain this, I used the follow measures/tables:
The original table for which I am trying to make the inverted selection
Cars_table
Table for slicer
Unique_brand = SUMMARIZE('Cars_table','Cars_table'[brand])
List of all selected values
selection_list =
VAR part_1 = CONCATENATE(UNICHAR(34),UNICHAR(44))
VAR part_2 = CONCATENATE(part_1, UNICHAR(34))
VAR core = CONCATENATEX(Unique_brand, [brand], part_2)
VAR with_lead = CONCATENATE(UNICHAR(34), core)
VAR with_tail = CONCATENATE(with_lead, UNICHAR(34))
RETURN with_tail
Table with result I want to obtain
Result_table= FILTER(
ALL('Cars_table'),NOT CONTAINSROW({selection_list}, 'Cars_table'[brand]))
However, the result table does not seem to interpret the 'selection_list'. There are no errors, but there is no filtering going on either...
Any help would be greatly appreciated.
Solved! Go to Solution.
Thank you! I solved it by using a measure in a table.
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |