FORMULAS TO FIND PERCENTAGES WITHIN THE BRAND, IN A ZONE AND ALSO WITHIN A BRANCH

[LUIS_CALLEJAS]

HI FRIENDS OF POWER BI FORUM. I WOULD LIKE YOUR HELP TO FIND A WAY TO DETERMINE THE 5 SALE OF A PRODUCT WITHIN THE HOLE COMPANY, AND ALSO WITHIN A ZONE AND ALSO WITHIN ITS BRANCH. I HAVE A TABLE IN WHICH I HAVE THE NUMBER OF THE OFFICE, THE DAT SOLD AND ALSO THE QUANTITY SOLD. IN ANOTHER TABLE I HAVE THE OFFICE NUMBER, THE ZONE THAT IT BELONG TOO AND ALSO THE BRANCH AS WELL. HOW CAN I DO TO GET THE PERCENTAGE SALE WITHIN THE HOLE COMPANY, THE PERCENTAGE SALE WITHIN ITS ZONE AND ALSO WITHIN ITS BRANCH?

MY EMAIL IS lcallejas2000@gmail.com

THANKS IN ADVANCE!

[LUIS_CALLEJAS]

https://docs.google.com/spreadsheets/d/1negNtgusjXw1fZ5Zz57EkOOsUnqWIkgI/edit?usp=drive_link&ouid=10...

Hi Fowmy!

This is my file.  I already tried as a new measurement:

ZONE = CALCULATE([QUANTITY],ALLEXCEPT('HELP POWER BI', 'HELP POWER BI'[Zone])), but it did not work. This to get the total for Zone, and similarly would be for Branch. The OP table is related to the PLACE table through the ADD table

I will appreciate your help.

[LUIS_CALLEJAS]

WORKING WITH REAL STATS, IN A PRODUCT I SOLD 41,739 UNITS. THE TOTAL QUANTITY SOLD WITHIN THE COUNTRY WAS 4,938,455. THE QUANTITY SOLD FOR THE ZONE IS 746,913, AND THE TOTAL FOR THE BRANCH IS 595,322. HOW DO I DIVIDE THE QUANTITY SOLD WITH THE TOTALS?

[Fowmy]

@LUIS_CALLEJAS 

It will be helpful if you could create a Power BI file with dummy data that represent your actual scenario and share it here. You may save the file in Google Drive and share the link here and grant permission to access the file. Explain the expected output as well.