Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Return a string from reference column

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 ...
Need Help
  • MattAllington's avatar
    MattAllington
    7 years ago

    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)

Stachu's avatar
Stachu
Community Champion
7 years ago

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