Sum select

reggieneo · 12-31-2019 04:15 PM

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

Kirk_Masden

Your second expression looks good to me. Doesn’t it work?

reggieneo

Hi,
No it doesn’t. It gives me the total of all.
Please see the image for ref.

Kirk_Masden

I’m afraid I don’t understand what the cause of the problem might be. I hope someone else can help. Good luck!

reggieneo

Hi all,
Anybody can help please?

Sergio_Sa

Hi @reggieneo Could you please try

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

Kirk_Masden

I made a little app called “Total practice” with the following expression:

if(isblank([first_name]),0,sum(SELECT( MOCK_DATA[Amount], [first_name] = [_THISROW].[first_name])))

The table name and the name of the columns are different but the expression works.

You can find the sample app here:

reggieneo

Foolish me. It’s an obvious mistake . Thanks. It worked!

Thanks for effort to help me too Kirk.