Look up value

[Amardeep100115]

Hi 

i wish have result on selection of bar graph, if i select city in graph and  result shoul be like below 

if i select Pune then result "Yes" and if i select Mumbai then "No"

[amitchandak]

@Amardeep100115 , not very clear , but you need something like

SWitch(true(), max(Table[City]) ="Pune", "YES",max(Table[City]) ="Mumbai", "No")

[parry2k]

@Amardeep100115 can you provide some more details and sample data not sure what you are referring too?

[Amardeep100115]

I wish to filter data on selection of bar in bar graph and results should be in card visual like values highlighted in green

hope i ma clear on my query

Sample Data 

[parry2k · Accepted solution]

@Amardeep100115 that should be easy, just create a measure for badge reader

Has Badge Reader Measure = 
IF ( HASONEVALUE ( Table[City] ), MAX( Table[Has Badge Reader] ), "SELECT A CITY" )

Put above measure in a card visual and it should work.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡