filter using dax

JAVED · ‎09-12-2018

Hi

i have data with product,price quntity,store quantiy

i creaed a table with product and price and card for Quantity and store quantity

Here in the card the qunatity and store Qunatity is dispalying as total.But i want to see it as initially one product value that is first one from the table then if i click on second product fromm table it should show second products value instead of taking filter how ca i do it

Plz help me

Anonymous · ‎09-13-2018

@JAVED,

You can create two measures in your table and drag the two measures to Card visuals.

QutntityMeasure = IF(ISFILTERED(Table[product]),SUM(Table[quantity]),CALCULATE(SUM(Table[quantity]),FILTER(Table,Table[product]="firstProductName")))

StoreMeasure = IF(ISFILTERED(Table[product),SUM(Table[store]),CALCULATE(SUM(Table[store]),FILTER(Table,Table[product]="firstProductName")))

If the above DAX don't work, please share sample data of your table and post expected result.

Regards,
Lydia

Anonymous · ‎09-13-2018

JAVED · ‎09-13-2018

@Anonymous

Part code	Part Name	Quality	Store	Total
86560-C7700	SPRING TRIM CLIP MTG	0	0	500
82610-A0010RA5	SPRING TRIM CLIP MTG	0	0	500
82610-A0010RA5	SPRING TRIM CLIP MTG	0	0	500
82610-A0010RA5	SPRING TRIM CLIP MTG	0	0	60
82610-A0010RA5	SPRING TRIM CLIP MTG	0	0	60
82610-A0010RA5	SPRING TRIM CLIP MTG	0	0	60
82610-A0010RA5	SPRING TRIM CLIP MTG	0	0	20
86511-C7700	SPRING TRIM CLIP MTG	0	0	500
86511-C7700	FOLDING ADESIVE	0	0	30
86511-C7700	KNOB ASSY GLOVE BOX	0	0	120
86511-C7700	KNOB ASSY GLOVE BOX	0	0	60
86511-C7700	KNOB ASSY GLOVE BOX	0	0	40
86511-C7700	T-SCREW	0	0	96
86511-C7700	T-SCREW	0	0	48
86511-C7700	T-SCREW	0	0	51
95720-1J001R2N	T-SCREW	0	0	60
95720-1J001R2N	RBI PULL HDL RR DR LH(S4)	0	0	60
86513-B4500	PNL CS CTR WOOD STOCK	0	0	60
86513-B4500	PNL CS CTR WOOD STOCK	0	0	135
86513-B4500	RBI PULL HANDLE RR DR RH(S4)	0	0	306
86513-B4500	FABRIC CUT PICES SAV RR LH	0	0	500
86513-B4500	FABRIC CUT PICES SAV RR LH	0	0	500
86514-B4500	INSERT NUT(M8)	0	0	180
86514-B4500	NUT SPRING	0	0	48
86514-B4500	NUT SPRING	0	0	48
86514-B4500	NUT SPRING	0	0	60
86514-B4500	NUT SPRING	0	0	252
87721-B4500	NUT SPRING	0	0	168
87721-B4500	NUT SPRING	0	0	40
87721-B4500	NUT SPRING	0	0	40
87721-B4500	NUT SPRING	0	0	40
87721-B4500	NUT SPRING	0	0	40
87722-B4500	NUT SPRING	0	0	75
87722-B4500	NUT SPRING	0	0	40
87722-B4500	NUT SPRING	0	0	40
87722-B4500	NUT SPRING	0	0	40
87722-B4500	NUT SPRING	0	0	40
87731-B4500	NUT SPRING	0	0	120
87731-B4500	NUT SPRING	0	0	50
87731-B4500	NUT SPRING	0	0	48
87731-B4500	NUT SPRING	0	0	160
87731-B4500	PULL HDL RR RH	0	0	60
87732-B4500	PULL HDL RR RH	0	0	180
87732-B4500	PULL HDL RR RH	0	0	180
87732-B4500	HARDNER	0	0	70
87732-B4500	HARDNER	0	0	70
87732-B4500	PULL HDL RR DR LH	0	0	99
82330-A0010TRY	PULL HDL RR DR LH	0	0	80
82330-A0010TRY	PULL HDL RR DR LH	0	0	120
82330-A0010TRY	RIVET BLIND	0	0	50
83620-C9000TRY	RIVET BLIND	0	0	150
83620-C9000TRY	RIVET BLIND	0	0	30
83620-C9000TRY	RIVET BLIND	0	0	100
83620-C9000TRY	BRKT-FR DR MT'G SUPPORT LH	0	0	420
86182-A0000	BRKT-FR DR MT'G SUPPORT LH	0	0	420
86182-A0000	HDL ASSY-FR DR I/S LH	0	0	300
86182-A0000	HDL ASSY-FR DR I/S LH	0	0	300
82394-A0000	HDL ASSY-FR DR I/S LH	0	0	200
82394-A0000	HDL ASSY-FR DR I/S LH	0	0	180
86512-C7700	NUT SPRING	0	0	54
86512-C7700	NUT SPRING	0	0	96
86512-C7700	NUT SPRING	0	0	2400
86512-C7700	NUT SPRING	0	0	30
86512-C7700	NUT SPRING	0	0	54
86512-C7700	NUT SPRING	0	0	30
86512-C7700	NUT SPRING	0	0	200
83340-A0010TRY	NUT SPRING	0	0	30
83340-A0010TRY	RBI PULL HANDLE FR DR RH	0	0	12
83340-A0010TRY	RBI PULL HANDLE FR DR RH	0	0	36
86613-B4500	RBI PULL HANDLE FR DR RH	0	0	30
86613-B4500	RBI COVER FR DR PULL HDL	0	0	200
86613-B4500	RBI COVER FR DR PULL HDL	0	0	200
86613-B4500	RBI COVER FR DR PULL HDL	0	0	90
86613-B4500	RBI COVER FR DR PULL HDL	0	0	100
86614-B4500	RBI PULL HANDLE FR DR LH	0	0	120
86614-B4500	RBI PULL HANDLE FR DR LH	0	0	120
86614-B4500	RBI PULL HANDLE FR DR LH	0	0	120
86614-B4500	LOGO ASSY	0	0	140
86614-B4500	PAB WARNING LABEL CHILD SEAT	0	0	80
83350-A0010TA6	PAB WARNING LABEL CHILD SEAT	0	0	60
83350-A0010TA6	COVER RR BUMPER FOG LAMP RH	0	0	4
82620-C9000TRY	RETAINER BPR SIDE MTG	0	0	48
82620-C9000TRY	RETAINER BPR SIDE MTG	0	0	40
82620-C9000TRY	RETAINER BPR SIDE MTG	0	0	40
82620-C9000TRY	RETAINER BPR SIDE MTG	0	0	40
83360-A0010TA6	RETAINER BPR SIDE MTG	0	0	40
83360-A0010TA6	RETAINER BPR SIDE MTG	0	0	40
82330-A0020TA2	RETAINER BPR SIDE MTG	0	0	40
82330-A0020TA2	RETAINER BPR SIDE MTG	0	0	150
82330-A0020TA2	RETAINER BPR SIDE MTG	0	0	150
82330-A0020TA2	RETAINER BPR SIDE MTG	0	0	72
82330-A0020TA2	RETAINER BPR SIDE MTG	0	0	15000
82330-A0020TA2	RETAINER BPR SIDE MTG	0	0	3000
82330-A0110TRY	RETAINER BPR SIDE MTG	0	0	102
82330-A0110TRY	RETAINER BPR SIDE MTG	0	0	500
82330-A0110TRY	RETAINER BPR SIDE MTG	0	0	1000
82330-A0120TA2	RETAINER BPR SIDE MTG	0	0	240
82330-A0120TA2	RETAINER BPR SIDE MTG	0	0	240
82330-A0120TA2	RETAINER BPR SIDE MTG	0	0	300
82330-A0120TA2	HDL ASSY-HOOD LATCH RELEASE	0	0	260
82330-A0120TA2	HDL ASSY-HOOD LATCH RELEASE	0	0	200
82330-A0120TA2	HDL ASSY-HOOD LATCH RELEASE	0	0	160
82340-A0010TRY	HDL ASSY-HOOD LATCH RELEASE	0	0	60
82340-A0010TRY	GROMMET SL ROD I-SANTRO COMM	0	0	200
82340-A0010TRY	GROMMET SL ROD I-SANTRO COMM	0	0	48
86562-C7710	PU LAMINATED FABRIC RR RH	0	0	210
86562-C7710	PAB WARNING LABEL-CHILD SEAT	0	0	2
83330-A0020TA2	PAB WARNING LABEL-CHILD SEAT	0	0	2
83330-A0020TA2	PACKING CVR	0	0	2
83330-A0020TA2	RAW MATERIAL	0	0	300
83330-A0020TA2	WSTRIP-RR DR IS BELT RH	0	0	91
83330-A0020TA2	WSTRIP-RR DR IS BELT RH	0	0	46
83330-A0020TA2	IB BAND RR TRANSVERSE	0	0	80
82620-A0010RA5	IB BAND RR TRANSVERSE	0	0	135
82620-A0010RA5	PAD-RR DR ARM REST-LH	0	0	500
82620-A0010RA5	HDL ASSY-HOOD LATCH	0	0	100
82620-A0010RA5	HDL ASSY-HOOD LATCH	0	0	36
82360-A0110TA6	HDL ASSY-HOOD LATCH	0	0	84
82360-A0110TA6	HDL ASSY-HOOD LATCH	0	0	12
82360-A0010TA6	HDL ASSY-HOOD LATCH	0	0	60
82360-A0110TA2	HDL ASSY-HOOD LATCH	0	0	81
82360-A0110TA2	HDL ASSY-HOOD LATCH	0	0	408
82360-A0010TA2	HDL ASSY-HOOD LATCH	0	0	200
82360-A0010TA2	HDL ASSY-HOOD LATCH	0	0	200
82350-A0110TA6	HDL ASSY-HOOD LATCH	0	0	300
82350-A0110TA6	HDL ASSY-HOOD LATCH	0	0	60
82376-A0000	HDL ASSY-HOOD LATCH	0	0	60
82376-A0000	HDL ASSY-HOOD LATCH	0	0	75
86153-C7010	HDL ASSY-HOOD LATCH	0	0	48
86153-C7010	HDL ASSY-HOOD LATCH	0	0	90
86153-C7010	HDL ASSY-HOOD LATCH	0	0	50
82331-1C000	HDL ASSY-HOOD LATCH	0	0	135
82331-1C000	HDL ASSY-HOOD LATCH	0	0	135
82341-1C000	HDL ASSY-HOOD LATCH	0	0	120
82341-1C000	HDL ASSY-HOOD LATCH	0	0	120
87713-1A500	PAD-FR DR AREST-LH	0	0	672
87713-1A500	PAD-FR DR AREST-RH	0	0	96
87715-1A500	PAD-FR DR AREST-RH	0	0	96
87723-1A500	PAD-RR DR ARMREST-RH	0	0	120
87723-1A500	ADHESIVE BOND TOLLENELESS	0	0	200
87724-1A500	CLIP ASSY-TRIM MTG	0	0	20
87724-1A500	CLIP ASSY-TRIM MTG	0	0	20
87736-1A500	CLIP ASSY-TRIM MTG	0	0	18
87756-35000	TRIMMED LEATHER CTR TRIM RR RH	0	0	60
87757-25500	TRIMMED LEATHER CTR TRIM RR RH	0	0	75
M21370-TYB	TRIMMED LEATHER CTR TRIM RR RH	0	0	96
M21370-TYB	TRIMMED LEATHER CTR TRIM RR RH	0	0	200
M21370-TYB	TRIMMED LEATHER CTR TRIM RR RH	0	0	72
M21370-TYB	TRIMMED LEATHER CTR TRIM RR RH	0	0	144
86587-B4500	HDL ASSY RR DR INSIDE HANDLE LH METAL COATING	0	0	48
86588-B4500	HDL ASSY RR DR INSIDE HANDLE LH METAL COATING	0	0	100
GN15-15K870-BA	HDL ASSY RR DR INSIDE HANDLE LH METAL COATING	0	0	60
GN15-15K870-BA	HDL ASSY RR DR INSIDE HANDLE LH METAL COATING	0	0	1000
GN15-15K871-BA	HDL ASSY RR DR INSIDE HANDLE LH METAL COATING	0	0	1000
GN15-15K871-BA	HDL ASSY RR DR INSIDE HANDLE LH METAL COATING	0	0	60
86156-H6000	TRIMMED LEATHER CTR TRIM FR RH RHD	0	0	13
86570-H6000	TRIMMED LEATHER CTR TRIM FR RH RHD	0	0	2
86511-H6000	TRIMMED LEATHER CTR TRIM FR RH RHD	0	0	1
86511-H6000	TRIMMED LEATHER CTR TRIM FR RH RHD	0	0	1
86511-H6000	TRIMMED LEATHER CTR TRIM FR RH RHD	0	0	1
86511-H6000	TRIMMED LEATHER CTR TRIM FR RH RHD	0	0	1
86511-H6000	HDL ASSY-RR DR INSIDE HANDLE LH	0	0	300
86611-H6000	HDL ASSY-RR DR INSIDE HANDLE LH	0	0	270
86611-H6000	HDL ASSY-RR DR INSIDE HANDLE LH	0	0	40
86611-H6000	HDL ASSY-RR DR INSIDE HANDLE LH	0	0	60
86611-H6000	HDL ASSY RR DR INSIDE RH METAL COATING	0	0	48
86611-H6000	HDL ASSY RR DR INSIDE RH METAL COATING	0	0	90
86354-H6000	HDL ASSY RR DR INSIDE RH METAL COATING	0	0	60
86355-H6000	HDL ASSY RR DR INSIDE RH METAL COATING	0	0	60
86367-H6000	HDL ASSY RR DR INSIDE RH METAL COATING	0	0	60
D1410-H6020XUG	HDL ASSY RR DR INSIDE RH METAL COATING	0	0	380
D1410-H6020PKG	PU LAMINATED FABRIC (ARM REST)	0	0	120
D1410-H6020TRY	NET HOOK ASSY	0	0	96
D1410-H6020RGD	NET HOOK ASSY	0	0	144

sample data

Screenshot (4).png

This is my desired report here the Quality,Store,In-Transit is showing total values but,Initially It should show only Starting part name values from the table then if we select Another part name it should show that part name value can we make it

Help would be appreciated

Anonymous · ‎09-13-2018

@JAVED,

Please create the following measures in your table.

QualityMeasure = IF(ISFILTERED(Table[Part No.]),SUM(Table[Quality]),CALCULATE(SUM(Table[Quality]),FILTER(Table,Table[Part No.]="00040026")))

StoreMeasure = IF(ISFILTERED(Table[Part No.),SUM(Table[Store]),CALCULATE(SUM(Table[Store]),FILTER(Table,Table[Part No.]="00040026")))

Regards,
Lydia

filter using dax

Issue with new card visual after publishing to PBI...

Issue with Card Visual Layout After November Power...

Automatically expand table columns to fill availab...

New Button Slicer: Issue with the Grid type of Arr...

List Slicer Button Dimensions Ignored in Service

FabCon is coming to Atlanta

filter using dax

Issue with new card visual after publishing to PBI...

Issue with Card Visual Layout After November Power...

Automatically expand table columns to fill availab...

New Button Slicer: Issue with the Grid type of Arr...

List Slicer Button Dimensions Ignored in Service