Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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