I have the two tables below and want to sum by product. I have linked to the two tables by product id but the sum for product ID gives me the results in the third pictures. I thought this will work seamlessly. Do I actually have to create a new table just to aggregate by product when I have linked to another table showing product cost?
Hi @Maureen
I would suggest you add a cost column with RELATED function as below.Then drag the cost column to table visual.
Cost = RELATED(A[Cost])
Regards,
Cherie
Hi @Maureen
I would suggest you add a cost column with RELATED function as below.Then drag the cost column to table visual.
Cost = RELATED(A[Cost])
Regards,
Cherie
Helpful resources
Power BI Monthly Update - November 2023
Check out the November 2023 Power BI update to learn about new features.
Fabric Community News unified experience
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
The largest Power BI and Fabric virtual conference
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.
