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
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
Solved! Go to 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 )
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 )
thanks a lot..
I have added drill down also.. how to calculate the drill down percentage for unit-id?
how to send the sample to you?
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 |
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.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |