Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have a table that contains countries.
There is another table with the same countries but used only to filter the first table, no relationship between them.
Now I would like to create a new column which indicates if a country is being selected or not. It works fine when I specify the country name but it does not work when I use the SELCTEDVALUE function which gives the same country that I specified.
SelectedCountry measure = SELECTEDVALUE(Country_Slicer[Select_a_Country])
I am confused. Can someone please explain why SELECTEDVALUE() --> Germany is not the same as "Germany"?
Solved! Go to Solution.
We can't pass filter selection to the calculated column. We have to create a DAX measure.
IsSelected =
IF (
SELECTEDVALUE ( Countries[Country] )
= SELECTEDVALUE ( CountriesSlicer[Country] ),
1,
0
)
We can't pass filter selection to the calculated column. We have to create a DAX measure.
IsSelected =
IF (
SELECTEDVALUE ( Countries[Country] )
= SELECTEDVALUE ( CountriesSlicer[Country] ),
1,
0
)
Yep, that works, thank you for the help and also for saving my nerves.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 82 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |