Sum select

Happy new year to All,
These formula give me the total sum of all the sales. What I need is only for the totals of the customer name.

SUM(SELECT( Orders[Total Cost],in([Name],list[_THISROW].[Name])

If(isblank([Name]),0,SUM(SELECT( Orders[Total Cost], ([Name] = [_THISROW].[Name]))))

Thanks

0 7 341
7 REPLIES 7
Top Labels in this Space