cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmh
Frequent Visitor

% from total, country based

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

CountryCompanySales% from All total (countryBased)
DKA8? (8/ (8+5)
DKB5?(5/ (8+5)
SEX6?
SEY7?
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

 

Jihwan_Kim_0-1664977125242.png

 

 

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

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

 

Jihwan_Kim_0-1664977125242.png

 

 

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


Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors