Forum Discussion

Frequent Visitor

4 years ago

Solved

search for a value and return multiple fields

Good afternoon: First of all, thank the people who answer it. What i need to do is the following: If they match a field (country) return me ALL the fields that meet the condition (city) ...

Tips

tamerj1
4 years ago
Hi 4pepesanchez4
You can use a table or matrix visual
Measure
Cities = CONCATENATEX ( Countries, Countries[city], " | " )

tamerj1

4 years ago

Hi 4pepesanchez4
Please use this

Cities = 
CONCATENATEX (
    Ventas_Compana_Google,
    Ventas_Compana_Google[Descripcion],
    " | "
)

4pepesanchez4

Frequent Visitor

4 years ago

hi again 😅 tamerj1

Could you help me understand why the formula gives me an error? The first field that the formula asks me for is the table (Ventas_Clientas_Origen), the expression (Nombre), Order by Expression ('Ventas_Campaña_Google'[Descripción]).

* My goal is to get the names of the clients related to the table (one-to-many relationship) to return all the services performed by said clients.

Thx a lot!!