cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer
Post Patron
Post Patron

selected value seams to not work properly

I used before and now it seems to not work I attach the powerbi file

 

https://www.dropbox.com/s/7pw7fkn7u0w3xef/TEST.pbix?dl=0

 

 

if slicer it is selected the display 1 otherwise 0

 

 

before was working why not? I do miss something?

 

1 ACCEPTED SOLUTION
MartynRamsden
Solution Sage
Solution Sage

Hi @snifer 

 

You only have one value ("local") in the column used for your slicer. As such, SELECTEDVALUE will always return "local", whether your slicer is selected or not. Resulting in your measure always returning 1.

 

If you add another record to your table, your measure will work as expected.

If you will only ever have one record in that table, you could use the ISFILTERED function instead.

 

Best regards,
Martyn


If I answered your question, please help others by accepting it as a solution.

View solution in original post

1 REPLY 1
MartynRamsden
Solution Sage
Solution Sage

Hi @snifer 

 

You only have one value ("local") in the column used for your slicer. As such, SELECTEDVALUE will always return "local", whether your slicer is selected or not. Resulting in your measure always returning 1.

 

If you add another record to your table, your measure will work as expected.

If you will only ever have one record in that table, you could use the ISFILTERED function instead.

 

Best regards,
Martyn


If I answered your question, please help others by accepting it as a solution.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.