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
The Power BI Community Show
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Ted's Dev Camp - July 28, 2022
Watch Session 24 of Ted's Dev Camp along with past sessions!
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
