Forum Discussion
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"...
What is the relationship between the tables?
Best
D
Best
D
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 Name | Company Supplier Id |
| Company A | 12345 |
| Company B | 12345 |
| Company C | 12345 |
Is there a way to alter the formula to get count of company id's per supplier?