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
Community Champion
4 years ago

4pepesanchez4  ğŸ˜…
Yes why not. It is for sure the easiest way.

4pepesanchez4's avatar
4pepesanchez4
Frequent Visitor
4 years ago

I'm sorry for my level of English. What I wanted to say is that the definition proposal is through a DAX formula (CalculateX) and I'm using Excel, which doesn't give me the option to use that formula, right? Wouldn't there be another way to do the exercise without DAX formulas?

 

Thx

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    4pepesanchez4 
    It is CONCATENATEX not CALCULATEX
    and it is available in Excel's Power Pivot. It should work normally with no issues.