Forum Discussion
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 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
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)
3 Replies
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)
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
