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, you should use SELECTEDVALUE for both the filter and the table value, and compare these directly. give this a try, and if you encounter any issues, let me know.
MyColumn =
IF(
SELECTEDVALUE('MyTable'[TYPE]) = SELECTEDVALUE('MyTable'[TYPE], BLANK()),
[Concatenation],
BLANK()
)
Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Specialist!
Hello ahadkarimi,
Thanks for your help.
Unfortunately, it doesn't works.
No matter what is the value i choose in my filter, every single value is display in the table. I don't have blank cells in my column.
VALUES return a table of unique values and SELECTEDVALUE returns a single value.So the equality comparision isnt valid.
Hello,
I didn't find a solution to my issue.
Anyway, thanks for your help.
