Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |