CALCULATE PERCENTAGE

[srkase]

Hi 

I have created a matrix table in the following manner

branch	product	spares	%
chennai	10000	500	?
		? I want to create the percentage of spares on 10000

I have kept all the data in a single table... differentiated by category... category consists of product , spares and cable.

Kindly guide me... and thanks in advance

[Mariusz · Accepted solution]

Hi @srkase 

Try this.

% of Spares = 
VAR _products = CALCULATE(
    SUM( YourTable[TOTAL QTY] ), 
    YourTable[CATEGORY] = "PRODUCT"
)
VAR _spares = CALCULATE(
    SUM( YourTable[TOTAL QTY] ), 
    YourTable[CATEGORY] = "SPARES"
)
RETURN DIVIDE( _spares, _products )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[srkase]

thanks a lot..

I have added drill down also..  how to calculate the drill down percentage for unit-id?

[Mariusz]

Hi @srkase 

Please can you provide a data sample?

Best Regards,
Mariusz

Please feel free to connect with me.

[srkase]

how to send the sample to you?

[Mariusz]

Hi @srkase 

You can create a sample table in excel and paste it here.

Best Regards,
Mariusz

Please feel free to connect with me.

[srkase]

YEAR	SHORTNAME	DEALER	TYPE	MAJOR GROUP	MINOR GROUP	SUB GROUP	PRODUCT	VARIANT	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	JAN	FEB	MAR	TOTAL QTY	TOTALVAL	PTA_DESTINATION	UNIT_CODE	PTA_DISTRICT	PTA_TALUK	PTA_PIN	ACP_ENTRYDT	HP	PER	APR VAL	MAY VAL	JUN VAL	JUL VAL	AUG VAL	SEP VAL	OCT VAL	NOV VAL	DEC VAL	JAN VAL	FEB VAL	MAR VAL	TOTAL CR	DLR NAME_DEST	DEST_DST_PIN	DST_DEST_PIN	PIN_DEST_DST	CATEGORY
20172018	TCR	4	STD	SUBMERSIBLES	6" SET	EMS+ESRS	EMS7MS + ESRS31-23	33AAA + 13FAA	1	0	0	0	0	0	0	0	0	0	0	0	1	15000	VADAKKENCHERRY	ASE1	PALAKKAD	ALATHUR	678683	########	7.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	CHANS ELECTRICALS VADAKKENCHERRY	VADAKKENCHERRY PALAKKAD 678683	PALAKKAD VADAKKENCHERRY 678683	678683VADAKKENCHERRY PALAKKAD	PRODUCT
20172018	TCR	5	STD	SUBMERSIBLES	6" SET	EMS+ESRS	EMS5MS + ESRS31-15	33AAA + 13FAA	1	0	0	0	0	0	0	0	0	0	0	0	1	15000	SULTHAN BATHERY	ASE1	WAYANAD	SULTHANBATHERY	673592	########	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	GRANPA MARKETING CORPORATION SULTHAN BATHERY	SULTHAN BATHERY WAYANAD 673592	WAYANAD SULTHAN BATHERY 673592	673592SULTHAN BATHERY WAYANAD	PRODUCT
20182019	TCR	6	STD	SUBMERSIBLES	6" SET	EMS+ESRS	EMS7MS + ESRS51-08	33AAA + 13FAA	1	0	0	0	0	0	0	0	0	0	0	0	1	15000	KOZHINJAMPARA	ASE1	PALAKKAD	CHITTUR	678555	########	7.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	VISHNU ELECTRICALS KOZHINJAMPARA	KOZHINJAMPARA PALAKKAD 678555	PALAKKAD KOZHINJAMPARA 678555	678555KOZHINJAMPARA PALAKKAD	PRODUCT
20192020	TCR	8	STD	SUBMERSIBLES	6" SET	EMS+ESRS	EMS5MS + ESRS42-10	33AAA + 13FAA	1	0	0	0	0	0	0	0	0	0	0	0	1	15000	VADAKKENCHERRY	ASE1	PALAKKAD	ALATHUR	678683	########	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	CHANS ELECTRICALS VADAKKENCHERRY	VADAKKENCHERRY PALAKKAD 678683	PALAKKAD VADAKKENCHERRY 678683	678683 VADAKKENCHERRY PALAKKAD	PRODUCT
20192020	TCR	9	STD	SUBMERSIBLES	6" SET	EMS+ESRS	EMS5MS + ESRS36-12	33AAA + 13FAA	1	0	0	0	0	0	0	0	0	0	0	0	1	15000	PAZHAYANNUR	ASE1	THRISSUR	THALAPILLY	680587	########	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	GUARANTY PUMPS & BOREWELLS PAZHAYANNUR	PAZHAYANNUR THRISSUR 680587	THRISSUR PAZHAYANNUR 680587	680587 PAZHAYANNUR THRISSUR	PRODUCT
20182019	TCR	10	STD	SUBMERSIBLES	6" SET	ST+RS-S	ST075D + RS31SS/30	31AAA + 21FAA	1	0	0	0	0	0	0	0	0	0	0	0	1	15000	KOTTAYAM	ASE1	KOTTAYAM	KOTTAYAM	686001	########	10	0	0	0	0	0	0	0	0	0	0	0	0	0	0	KOTTAYAM MOTOR HOUSE KOTTAYAM	KOTTAYAM KOTTAYAM 686001	KOTTAYAM KOTTAYAM 686001	686001KOTTAYAM KOTTAYAM	PRODUCT
20172018	TCR	15	STD	SPARES	SPARES	SPARES	IMPELLER HCS725H / ASMSP725H (SS) (SP)	0	0	0	0	0	0	0	0	5	0	0	0	5	1900	SULTHAN BATHERY	ASE2	WAYANAD	SULTHANBATHERY	673592	########		0	0	0	0	0	0	0	0	0	0	0	0	0	0	GRANPA MARKETING CORPORATION SULTHAN BATHERY	SULTHAN BATHERY WAYANAD 673592	WAYANAD SULTHAN BATHERY 673592	673592     SULTHAN BATHERY                                              WAYANAD	SPARES
20172018	TCR	16	STD	SPARES	SPARES	SPARES	IMP+DIFF ASSY JRF06 (SPS)	0	0	0	0	0	0	0	0	45	0	0	0	45	2000	MANANTHAVADY	ASE4	WAYANAD	MANANTHAVADY	670645	########		0	0	0	0	0	0	0	0	0	0	0	0	0	0	KUZHIKANDATHIL PLUMPING&ELECTRICALS MANANTHAVADY	MANANTHAVADY WAYANAD 670645	WAYANAD MANANTHAVADY 670645	670645     MANANTHAVADY                                                 WAYANAD	SPARES
20172018	TCR	17	STD	SPARES	SPARES	SPARES	IMP+DIFF ASSY JRF09 (SPS)	0	0	0	0	0	0	0	0	45	0	0	0	45	2100	MANANTHAVADY	ASE4	WAYANAD	MANANTHAVADY	670645	########		0	0	0	0	0	0	0	0	0	0	0	0	0	0	KUZHIKANDATHIL PLUMPING&ELECTRICALS MANANTHAVADY	MANANTHAVADY WAYANAD 670645	WAYANAD MANANTHAVADY 670645	670645     MANANTHAVADY                                                 WAYANAD	SPARES
20182019	TCR	19	STD	SPARES	SPARES	SPARES	DIFFUSER HOUSING RS30/35/40 (SPS)	0	0	0	0	0	0	0	0	12	0	0	0	12	2300	KOTTAYAM	ASE1	KOTTAYAM	KOTTAYAM	686001	########		0	0	0	0	0	0	0	0	0	0	0	0	0	0	KOTTAYAM MOTOR HOUSE KOTTAYAM	KOTTAYAM KOTTAYAM 686001	KOTTAYAM KOTTAYAM 686001	686001     KOTTAYAM                                                     KOTTAYAM	SPARES
20182019	TCR	20	STD	SPARES	SPARES	SPARES	PAN HEAD SCREW MS M5 X 16 MM (SP)	0	0	0	0	0	0	0	0	100	0	0	0	100	2400	QUILANDY	ASE2	KOZHIKODE	KOYILANDI	673305	########		0	0	0	0	0	0	0	0	0	0	0	0	0	0	COSMOS ELECTRICALS QUILANDY	QUILANDY KOZHIKODE 673305	KOZHIKODE QUILANDY 673305	673305     QUILANDY                                                     KOZHIKODE	SPARES