Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
Been reading AND trying all calculation possible but with no real results.. I want to calculate the % of total sales by product, my table looks like below and I have a total of 3 years in... Help - Thank you Natacha
Relative continuous month | Wholesaler | Practice name | DDMS code | Postal code | Product | Product group | Therapeutic Domain | Sales Territory: TVM Territory | Rebate Groups | FOC | Value (£) | No. packs sold (number) | CALENDAR YEAR | QUARTER |
January-18 | Agrihealth NI | EAST DOWN FARMERS LTD | 401243 | BT30 7EU | SCOURPROOF EXTRA 4X16X100 | SCOURPROOF | Gastroenterology | William Baird | NONE | PAID | 32.49 | 1 | 2018 | Q1 |
January-18 | Agrihealth NI | FRANCIS CONNON GENERAL MERCHANTS | 401227 | BT42 3HL | SCOURPROOF EXTRA 2X40X100 | SCOURPROOF | Gastroenterology | William Baird | NONE | FOC | 80.82 | 1 | 2018 | Q1 |
January-18 | Agrihealth NI | FRANCIS CONNON GENERAL MERCHANTS | 401227 | BT42 3HL | SCOURPROOF EXTRA 2X40X100 | SCOURPROOF | Gastroenterology | William Baird | NONE | PAID | 808.20 | 10 | 2018 | Q1 |
January-18 | Agrihealth NI | GLENS FARM SUPPLIES | 402380 | BT44 0RR | SCOURPROOF EXTRA 2X40X100 | SCOURPROOF | Gastroenterology | William Baird | NONE | PAID | 889.02 | 11 | 2018 | Q1 |
January-18 | Agrihealth NI | STEELE FARM SUPPLIES | 401339 | BT53 6EE | SCOURPROOF EXTRA 2X40X100 | SCOURPROOF | Gastroenterology | William Baird | NONE | PAID | 1,778.04 | 22 | 2018 | Q1 |
January-18 | Agrihealth NI | ULSTER LIVESTOCK CARE | 401353 | BT45 7NS | SCOURPROOF EXTRA 2X40X100 | SCOURPROOF | Gastroenterology | William Baird | NONE | PAID | 161.64 | 2 | 2018 | Q1 |
Solved! Go to Solution.
See the attached file for a possible solution
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi, @Glamour16
You may create a measure as below.
Result =
DIVIDE(
SUM('Table'[Value]),
CALCULATE(
SUM('Table'[Value]),
ALLSELECTED('Table')
)
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I also got 100% in all columns for all products, please help where it went wrong..
Hi, @Glamour16
You may create a measure as below.
Result =
DIVIDE(
SUM('Table'[Value]),
CALCULATE(
SUM('Table'[Value]),
ALLSELECTED('Table')
)
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Allan, but I get 100% everywhere, I must be missing something?
See the attached file for a possible solution
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Thank you. I know it is correct but it give me 100% in all columns for all product...
Hi @Glamour16
Please explain what the expected result would be for the sample data provided
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.