Forum Discussion
Solved
Summing by Client
Please see below 2 tables. I would like to bring in total sales from column B into Column A. However I do not want the total sales to be repeated if a client in table A has multiple rows. Is it possi...
Hi homboy27,
Thank you for reaching out to Microsoft Fabric Community Forum.
can you try with this calculated column and let us know if you face any issues.this will pull total sales per client from Table B into Table A, but only show it once per client, on a specific row.
TotalSales_Once = VAR CurrentClient = TableA[Client] VAR CurrentLocation = TableA[Location] VAR IsFirstRow = TableA[Location] = CALCULATE( MIN(TableA[Location]), FILTER(TableA, TableA[Client] = CurrentClient) ) VAR TotalSales = CALCULATE( SUM(TableB[Sales]), FILTER(TableB, TableB[Client] = CurrentClient) ) RETURN IF(IsFirstRow, TotalSales, 0)Regards,
Chaithanya.
Please see below the desired section. I am pulling the total sales from Table B into Table A. However I only want the sales for client A to be on 1 column and not on all the columns. So i would like the number that I highlighted to be 0 and not pull in $10k.
