Percentage of total sales by product

[Glamour16]

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

[AlB · Accepted solution]

@Glamour16 

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 

[sneha_rudra]

Hi,

I also got 100% in all columns for all products, please help where it went wrong..

[v-alq-msft · Accepted solution]

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.

[Glamour16]

Thanks Allan, but I get 100% everywhere, I must be missing something?

[AlB · Accepted solution]

@Glamour16 

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 

[Glamour16]

Thank you. I know it is correct but it give me 100% in all columns for all product...

[AlB]

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