Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anaïs
Regular Visitor

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 5
Anonymous
Not applicable

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.

vmengmlimsft_0-1727171267669.png

 

 

 

 

Best regards,

Mengmeng Li

ahadkarimi
Solution Specialist
Solution Specialist

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.



Regards,
Sachin
Check out my Blog

Hello,

I didn't find a solution to my issue. 

Anyway, thanks for your help.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.