Forum Discussion

Anaïs's avatar
Anaïs
Regular Visitor
1 year ago

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 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.

5 Replies

  • ahadkarimi's avatar
    ahadkarimi
    Solution Specialist
    1 year ago

    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's avatar
      Anaïs
      Regular Visitor
      1 year ago

      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's avatar
        SachinNandanwar
        Impactful Individual
        1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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