Would like to find % from total (country based) for each company: the sample data as:
Go to Solution.
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] ) )
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.
View solution in original post
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.