Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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"

Company Id from the "Intake Data" table

 

I've tried this:

Table = SUMMARIZE('Company_Supplier'[Company_Supplier_Name])
+SUMMARIZE('looker_views lkr_Intake_Data',[Company_Id])
 
Yet I encounter the error:The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
 
Can anyone help?
2 REPLIES 2
Anonymous
Not applicable

What is the relationship between the tables?

Best
D
Anonymous
Not applicable

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors