Forum Discussion
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) ...
Hi 4pepesanchez4
You can use a table or matrix visualMeasure
Cities = CONCATENATEX ( Countries, Countries[city], " | " )Hi 4pepesanchez4
Please use thisCities = CONCATENATEX ( Ventas_Compana_Google, Ventas_Compana_Google[Descripcion], " | " )
The field “Clienta” (severals) and field “Name” (single) is the active relationship between tables.
In the table of the "Clienta" field I have all the services that the clients have performed in the month (each service is a line so there are repeated lines) and in the second table the field "Name" are the clients that have come through from Google so it is a unique field.
I do not have the "Name" field defined as any measure. It is simply the unique name of each client and what I want it to return is the "Description" field of the table (Ventas_Camapaña_Google) to know what services those clients have performed.
tamerj1
Community Champion
Community ChampionHi 4pepesanchez4
Please use this
Cities =
CONCATENATEX (
Ventas_Compana_Google,
Ventas_Compana_Google[Descripcion],
" | "
)