Return a string from reference column

[Anonymous]

Hi,

My issue is that I have tickets that are coming from diffrent countrys and I use a card in Power BI to show which country they are coming from. When I just apply the country on the card it's showing "first of country", but that could be missleading. I want it to only show the country if a specific ticket is selected.

How could I with a measurement do that?

I've come so far, but the last false statement ('SNOW(sn_sm_finance_request)'[country]) doesn't work.

Ticket Market = IF('SNOW(sn_sm_finance_request)'[Total ticket]>1; "No Specific Selected Ticket"; 'SNOW(sn_sm_finance_request)'[country])

The thing is that it work if I'm just writing "country" insted of the reference table, then it appears "country" when a specific ticket is selected. But I don't want that I want it to show the specific country for the selected ticket.

Ticket Market = IF('SNOW(sn_sm_finance_request)'[Total ticket]>1; "No Specific Selected Ticket"; "country")

I hope you understand. Just ask if you don't.

Regards, 

Albin

[Stachu]

this should work as long as tickets cannot have more than 1 country

Ticket Market = IF('SNOW(sn_sm_finance_request)'[Total ticket]>1; "No Specific Selected Ticket"; VALUES('SNOW(sn_sm_finance_request)'[country]))

you could also use

Ticket Market = SELECTEDVALUE('SNOW(sn_sm_finance_request)'[country],"No Specific Selected Ticket")

but it will return Country as long as there is only single one coming from the tickets selection

[MattAllington · Accepted solution]

You want the selectedvalue function. This does exactly what you want. It returns a value only if there is a single value, otherwise it returns blank (or an optional alternate)

[Anonymous]

Thank you! Now it works.

Regards,

Albin