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)
Thank you very much in advance,
Solved! Go to Solution.
HI @tamerj1 !
How should I write the formula in Power Pivot knowing that the relationship between countries and tables is already done and that Country is in a different table than city?
Thanx you a lot!!
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!!
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.
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.