PlantFP Product DescriptionSFG Product DescriptionFP BatchRM BatchRM Material CodeRM Material descriptionBulk BatchBulk Material CodeBulk Posting DateSFG Batch 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950157797100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161447100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161448100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161448100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950161448100505875METFORMIN HCL PH EUR (EXEMED) (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950165213100506782SITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)31606066105527112-Oct-223160606 12METF/SITA TAB 1000/50MG 56BL CY/GR MYSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P814744950165377100506782SITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)31606066105527112-Oct-223160606TAble BStage of AnalysisMaterial NameBatch NumberCQA ResultFinshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1Assay by HPLC99.7Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1Avg. Uniformity of Dosage units7.9Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1Water Content (By KF) 4.690474Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1NTTP Impuity0.15SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Assay by HPLC101.0SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Assay by HPLC100.0SFGSitagliptin Tab. 25 mg EU_P3179069Assay by HPLC99.2SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Avg. Uniformity of Dosage units3.3SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Avg. Uniformity of Dosage units2.8SFGSitagliptin Tab. 25 mg EU_P3179069Avg. Uniformity of Dosage units2.8SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Water Content (By KF) 3.21SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Water Content (By KF) 4.726872SFGSitagliptin Tab. 25 mg EU_P3179069Water Content (By KF) 5.382045SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261NTTP Impuity0.17SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851NTTP Impuity0.16SFGSitagliptin Tab. 25 mg EU_P3179069NTTP Impuity0.16BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Assay by HPLC101.0BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Assay by HPLC100.0BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Moisture Content6.1BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Moisture Content1.5RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Assay by HPLC99.9RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Assay by HPLC99.9RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Individual unspecified Impurity0.100RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Individual unspecified Impurity0.100Vendor COAMETFORMIN HCL PH EUR (EXEMED) (EU)117002P01OIndividual unspecified Impurity0.000Vendor COAMETFORMIN HCL PH EUR (EXEMED) (EU)20150600Individual unspecified Impurity0.100Vendor COASITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)20152062NTTP Impuity0.08Vendor COASITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)20153890NTTP Impuity0.04I have two table Table-A , Table-B Table-Aplant , RM batch no., Blk Batch no., sfg batch no., fp batch no., fp material desc,..TAble-BStage of analysi(RM ,Blk ,sfg,fp..),Batch Number,Material name, Analysis name,result there is no common field in this two table ,RM batch no.,Blk batch no.,....as slicers at top and requiremet is if we filter from slicers in a table we need to get all related batches with result.here all batch no's are related to one another.

Thanks for the response,but here we need slicers at top and we are using sankey chart for there relation of batches like Vendor>RM RM>bulk Blk>sfg,,,,as such

Hi Anonymous Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...Please show the expected outcome based on the sample data you provided.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Aren't column 'RM Batch' of table A and column 'Batch Number' of table B the same type of data?There are a same number '50157797'.

batch number in table B is combination of all types of batchs from table A

Anonymous

Not applicable

2 years ago

Releationship

Plant	FP Product Description	SFG Product Description	FP Batch	RM Batch	RM Material Code	RM Material description	Bulk Batch	Bulk Material Code	Bulk Posting Date	SFG Batch
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50157797	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161447	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161448	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161448	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50161448	100505875	METFORMIN HCL PH EUR (EXEMED) (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50165213	100506782	SITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)	3160606	61055271	12-Oct-22	3160606
12	METF/SITA TAB 1000/50MG 56BL CY/GR MY	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	8147449	50165377	100506782	SITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)	3160606	61055271	12-Oct-22	3160606

TAble B

Stage of Analysis	Material Name	Batch Number	CQA	Result
Finshed Product	SITA/METF TAB 50MG/1000MG 60BL FR MY	3168665P1	Assay by HPLC	99.7
Finshed Product	SITA/METF TAB 50MG/1000MG 60BL FR MY	3168665P1	Avg. Uniformity of Dosage units	7.9
Finshed Product	SITA/METF TAB 50MG/1000MG 60BL FR MY	3168665P1	Water Content (By KF)	4.690474
Finshed Product	SITA/METF TAB 50MG/1000MG 60BL FR MY	3168665P1	NTTP Impuity	0.15
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3157261	Assay by HPLC	101.0
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3172851	Assay by HPLC	100.0
SFG	Sitagliptin Tab. 25 mg EU_P	3179069	Assay by HPLC	99.2
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3157261	Avg. Uniformity of Dosage units	3.3
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3172851	Avg. Uniformity of Dosage units	2.8
SFG	Sitagliptin Tab. 25 mg EU_P	3179069	Avg. Uniformity of Dosage units	2.8
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3157261	Water Content (By KF)	3.21
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3172851	Water Content (By KF)	4.726872
SFG	Sitagliptin Tab. 25 mg EU_P	3179069	Water Content (By KF)	5.382045
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3157261	NTTP Impuity	0.17
SFG	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3172851	NTTP Impuity	0.16
SFG	Sitagliptin Tab. 25 mg EU_P	3179069	NTTP Impuity	0.16
Bulk	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3157261	Assay by HPLC	101.0
Bulk	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3172851	Assay by HPLC	100.0
Bulk	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3157261	Moisture Content	6.1
Bulk	Sita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P	3172851	Moisture Content	1.5
RM	METFORMIN HCL PH EUR (EXEMED) (EU)	50157797	Assay by HPLC	99.9
RM	METFORMIN HCL PH EUR (EXEMED) (EU)	50157797	Assay by HPLC	99.9
RM	METFORMIN HCL PH EUR (EXEMED) (EU)	50157797	Individual unspecified Impurity	0.100
RM	METFORMIN HCL PH EUR (EXEMED) (EU)	50157797	Individual unspecified Impurity	0.100
Vendor COA	METFORMIN HCL PH EUR (EXEMED) (EU)	117002P01O	Individual unspecified Impurity	0.000
Vendor COA	METFORMIN HCL PH EUR (EXEMED) (EU)	20150600	Individual unspecified Impurity	0.100
Vendor COA	SITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)	20152062	NTTP Impuity	0.08
Vendor COA	SITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)	20153890	NTTP Impuity	0.04

I have two table Table-A , Table-B

Table-A

plant , RM batch no., Blk Batch no., sfg batch no., fp batch no., fp material desc,..

TAble-B

Stage of analysi(RM ,Blk ,sfg,fp..),Batch Number,Material name, Analysis name,result

there is no common field in this two table ,RM batch no.,Blk batch no.,....as slicers at top and requiremet is if we filter from slicers in a table we need to get all related batches with result.

here all batch no's are related to one another.

Need Help

Tips and Tricks

Forum Discussion

Releationship

9 Replies

Related content

Wrong releationship of Table values

Re: struggling with count of specific rows against count of all rows

Re: Presenting data from two child tables generate error

Re: Filter values in one table based on selection in another table

Re: Derive Column based on Slicer selection