topic Re: Problem between filter and table in DAX Commands and Tips

Problem between filter and table

Anaïs — Wed, 11 Sep 2024 09:32:42 GMT

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.

Re: Problem between filter and table

ahadkarimi — Wed, 11 Sep 2024 17:21:05 GMT

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!

Re: Problem between filter and table

Anaïs — Mon, 16 Sep 2024 07:44:49 GMT

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.

Re: Problem between filter and table

SachinNandanwar — Mon, 16 Sep 2024 14:16:44 GMT

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

Re: Problem between filter and table

Anaïs — Tue, 17 Sep 2024 12:34:54 GMT

Hello,

I didn't find a solution to my issue.

Anyway, thanks for your help.

Re: Problem between filter and table

Anonymous — Tue, 24 Sep 2024 09:49:04 GMT

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