Forum Discussion

4pepesanchez4's avatar
4pepesanchez4
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's avatar
    tamerj1
    4 years ago

    Hi 4pepesanchez4 
    You can use a table or matrix visual

    Measure 

    Cities = 
CONCATENATEX (
    Countries,
    Countries[city],
    " | "
)
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi 4pepesanchez4 
    Please use this

    Cities = 
CONCATENATEX (
    Ventas_Compana_Google,
    Ventas_Compana_Google[Descripcion],
    " | "
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi 4pepesanchez4 
You can use a table or matrix visual

Measure 

Cities = 
CONCATENATEX (
    Countries,
    Countries[city],
    " | "
)