% from total, country based

[mmh]

Would like to find % from total (country based) for each company: the sample data as: 

Country	Company	Sales	% from All total (countryBased)
DK	A	8	? (8/ (8+5)
DK	B	5	?(5/ (8+5)
SE	X	6	?
SE	Y	7	?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

Percentage by country: =
VAR _countrysales =
    CALCULATE ( [Sales:], ALLEXCEPT ( Data, Data[Country] ) )
RETURN
    DIVIDE ( [Sales:], _countrysales )