How to divide a measure on a value of a column of a linked table?

[PowerRon]

Hi

I would like to describe a problem in simplified form.
I have a fact table with transactions, that is linked to a country-tabel by country-key. Country - Fact = one to many.
Every transaction is counted as 1 in my explicit measure [Sum of Transactions].
The country-table contains country-key and country-code.
Country-code can be FR, IT, IE etc.

Now I want to make two rows in a matrix with [Sum of Transactions]:

• row 1 where country-code = ES (home country)
• row 1 where country-code <> ES

What is the best and easiest way to solve this if I can't change the country-table in the source?

Add another column to the view with ES-transactions and not-ES-transactions?? (this division will always be made, since ES is home country)

Add a calculated column to the country-table in Power Query? This column has two values: 'ES' for country ES and 'non-ES' for all other countries.

Create two extra measures with the DAX RELATED function, one [Sum of ES Transactions], one [Sum of non-ES transactions]?

How would this DAX formula look like?

Or is using grouping in the country table an option? Group 1 = ES, group 2 = non-ES

I don't know what is the best option and if there are even better options. Hope someone can help.

regards 

Ron

[Greg_Deckler]

@PowerRon Create 2 measures and use "Show as rows"

[PowerRon]

Hi @Greg_Deckler 

thnx for your answer.
But how would the measures look like then? And what do you mean with "Show as rows"?

Is it possible to help me a little bit, because it is not completely clear to me

regards

Ron