please help with modeling or measurement

[jcamilo1985]

Good Morning

As you are experts, I never thought that the subject of working with relationships and measures was so exhausting, I come to you because I have nowhere else to consult more directly and because I know that you are very skilled with this tool.

Get to the following data model:

 

In the table "directorio ejecutivo" is the Region attribute

I need to filter by a specific region the table "directorio empresas"

I accept modeling solutions or dax measurements
Any help would be appreciated

[v-lionel-msft · Accepted solution]

Hello @jcamilo1985 ,

Like this?

See my .pbix file. I built a sample model.

Best regards
Lionel Chen

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Greg_Deckler]

@jcamilo1985 See if you can change the relationship between ventasEmpresa and directorio empresas from Single to Both without inactivating the relationship (dotted line)