Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
The relationship is Intake Data* ----- 1Supplier Data (Many to 1) based on the "Company Supplier id"
I've created a table with:
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?
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |