Forum Discussion
Problem between filter and table
Hello everyone, Here is my issue : I have a filter named "TYPE" then I choose a value. After in my table, it displays all the lines no matter what is the value choose in the filter (I choose to de...
Hi Anaïs ,
This is because SELECTEDVALUE gets blank when you disable the interaction. I recommend you active the interaction and create another custom table which contains all types. Here is my test for your reference.
The custom table.
CustomTable = VALUES(MyTable[TYPE])The measure.
MyColumn =
IF(
SELECTEDVALUE('CustomTable'[TYPE]) = MAX('MyTable'[TYPE]),
[Concatenation],
BLANK()
)In my test, measure will return 1 if selected name equals name of Arrive table.
Best regards,
Mengmeng Li