Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Creating table with 2 columns from different tables

I currently have 2 tables "Company Supplier" and "Intake Data"   I'm trying to use summarize function to create a table of values with only  Company Supplier Name from the "Company Supplier Table"...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago
What is the relationship between the tables?

Best
D
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The relationship is Intake Data* ----- 1Supplier Data (Many to 1) based on the "Company Supplier id"

     

    I've created a table with:

     

    Table = var CompanySupplierName = MAX('Intake_Data'[Company_Id])

    return
    SUMMARIZE(FILTER('Intake_Data','Intake_Data'[Company_Id] = CompanySupplierName),
    'Intake_Data'[Company Supplier Name],"Count Company Id", CompanySupplierName)
     
    However it's giving me the overall max value in the column:
    Company Supplier NameCompany Supplier Id
    Company A12345
    Company B12345
    Company C12345

     

    Is there a way to alter the formula to get count of company id's per supplier?