Problem between filter and table

[Anaïs]

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 delete the interaction between my table and my filter).
In this table, if the value chosen in the filter is equal to the "TYPE" column in my table, then I display a measure called "Concatenation" and if it's not equal, i display a blank.

I try several solutions but without the result expected.

an example of what I tried :

MyColumn =
IF(
SELECTEDVALUE('MyTable'[TYPE]) = VALUES('MyTable'[TYPE]),
[Concatenation],
BLANK()
)

Can someone have an idea ?

Thank you for your help.

[Anonymous]

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

[ahadkarimi]

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!

[Anaïs]

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.

[SachinNandanwar]

VALUES return a table of unique values and SELECTEDVALUE returns a single value.So the equality comparision isnt valid.

[Anaïs]

Hello,

I didn't find a solution to my issue. 

Anyway, thanks for your help.