Forum Discussion
search for a value and return multiple fields
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], " | " )
just change the table name to the cities table
Cities =
CONCATENATEX (
Cities,
Cities[city],
" | "
)
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!!
Which one is the many side? What is the code for the measure [Nombre]?
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.
Hi 4pepesanchez4
Please use thisCities = CONCATENATEX ( Ventas_Compana_Google, Ventas_Compana_Google[Descripcion], " | " )