topic Re: FORMULAS TO FIND PERCENTAGES WITHIN THE BRAND, IN A ZONE AND ALSO WITHIN A BRANCH in DAX Commands and Tips

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

LUIS_CALLEJAS — Sun, 26 Nov 2023 00:58:45 GMT

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!

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

LUIS_CALLEJAS — Sun, 26 Nov 2023 01:24:48 GMT

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?

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

Fowmy — Sun, 26 Nov 2023 06:47:51 GMT

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.

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

LUIS_CALLEJAS — Mon, 27 Nov 2023 02:16:47 GMT

https://docs.google.com/spreadsheets/d/1negNtgusjXw1fZ5Zz57EkOOsUnqWIkgI/edit?usp=drive_link&ouid=105082125028990009024&rtpof=true&sd=true

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.