Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Releationship

‎10-11-2023 09:40 PM

 

  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-223160606

TAble B

Stage of AnalysisMaterial NameBatch NumberCQA Result
Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1Assay by HPLC99.7
Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1Avg. Uniformity of Dosage units7.9
Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1Water Content (By KF) 4.690474
Finshed ProductSITA/METF TAB 50MG/1000MG 60BL FR MY3168665P1NTTP Impuity0.15
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Assay by HPLC101.0
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Assay by HPLC100.0
SFGSitagliptin Tab. 25 mg EU_P3179069Assay by HPLC99.2
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Avg. Uniformity of Dosage units3.3
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Avg. Uniformity of Dosage units2.8
SFGSitagliptin Tab. 25 mg EU_P3179069Avg. Uniformity of Dosage units2.8
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Water Content (By KF) 3.21
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Water Content (By KF) 4.726872
SFGSitagliptin Tab. 25 mg EU_P3179069Water Content (By KF) 5.382045
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261NTTP Impuity0.17
SFGSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851NTTP Impuity0.16
SFGSitagliptin Tab. 25 mg EU_P3179069NTTP Impuity0.16
BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Assay by HPLC101.0
BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Assay by HPLC100.0
BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3157261Moisture Content6.1
BulkSita. Metf.Hyd.FC Tab. 50 /1000 mg EU_P3172851Moisture Content1.5
RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Assay by HPLC99.9
RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Assay by HPLC99.9
RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Individual unspecified Impurity0.100
RMMETFORMIN HCL PH EUR (EXEMED) (EU)50157797Individual unspecified Impurity0.100
Vendor COAMETFORMIN HCL PH EUR (EXEMED) (EU)117002P01OIndividual unspecified Impurity0.000
Vendor COAMETFORMIN HCL PH EUR (EXEMED) (EU)20150600Individual unspecified Impurity0.100
Vendor COASITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)20152062NTTP Impuity0.08
Vendor COASITAGLIPTIN HCL CRYS H2O (SIY) IH (EU)20153890NTTP Impuity0.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.

Labels:
Message 1 of 10
674 Views
0
9 REPLIES 9
mickey64
Super User
Super User

‎10-11-2023 11:47 PM

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'.

Message 4 of 10
633 Views
0
Anonymous
Not applicable
In response to mickey64

‎10-12-2023 12:08 AM

same data but only one change in table A that batch types are in separate columns in table B they are in only one column there is no common column to add relationship b/w two tables

Message 10 of 10
611 Views
0
Anonymous
Not applicable
In response to mickey64

‎10-11-2023 11:51 PM

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

Message 5 of 10
630 Views
0
mickey64
Super User
Super User
In response to Anonymous

‎10-12-2023 12:05 AM

Wouldn't the problem be solved by unpivoting all batch number columns in table A?

Message 6 of 10
613 Views
0
mickey64
Super User
Super User
In response to mickey64

‎10-12-2023 12:40 AM

For your reference.

 

Step 1: I unpivot 'Table-A'.

    mickey64_0-1697096004284.png

 

Step 2: I make a summarize table 'Batch Number Table'.

    Batch Number Table = SUMMARIZE('Table-A','Table-A'[Batch Number])

 

    mickey64_1-1697096087261.png

 

Step 3: I add 2 relationships.

    mickey64_2-1697096156660.png

    mickey64_3-1697096186892.png

 

Step 4: I make 2 'Table' visuals.

    mickey64_4-1697096315740.png

    

    mickey64_5-1697096390004.png

 

Step 5: I click '50157797' of 'Table-A'.

    mickey64_0-1697096890444.png

    

 

 

 

 

Message 7 of 10
594 Views
0
Anonymous
Not applicable
In response to mickey64

‎10-16-2023 10:38 PM

requirement is posted ,can i get any suggestion.

Message 9 of 10
545 Views
0
Anonymous
Not applicable
In response to mickey64

‎10-12-2023 01:08 AM

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

AnilBeerla_0-1697098017235.png

 

Message 8 of 10
584 Views
Ritaf1983
Super User
Super User

‎10-11-2023 10:17 PM

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Message 2 of 10
657 Views
0
Anonymous
Not applicable
In response to Ritaf1983

‎10-11-2023 10:43 PM

mentioned related information

Message 3 of 10
650 Views
0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All