Solved: Re: % from total, country based

mmh · ‎10-05-2022

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 · ‎10-05-2022

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 )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

View solution in original post

Jihwan_Kim · ‎10-05-2022

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 )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

% from total, country based

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024