topic Re: Get the sum by month in columns in DAX Commands and Tips

Get the sum by month in columns

Ludovicooo — Tue, 13 Dec 2022 10:41:26 GMT

Hello,

Hello everybody,

I try to obtain with a formula the grand total for each month in my shops regarding the global. I try to have in a column the sum of visits for july for example (10 000 visits + 30 000 visits + 60 000) in total visits column linked to the month and not the global.

Example :

Shop A > 10 000 Visits > Visit rate : 10% > July > Total visits 100 000

Shop B > 30 000 visits > Visit rate : 30% > July > Total visits 100 000

Shop C > 60 000 visits > Visit rate : 60% > July > Total visits 100 000

Grand total >>>>>>>> 300K€

I've tried this formula but it gives only the sum of visits for all the months and not the global visits by month :

test = SUMX(ALL('Couts Piano 2'),'Couts Piano 2'[Total Server call])

Any idea how can I have total visits in colum by month ?

Thanks a lot

Re: Get the sum by month in columns

Anonymous — Tue, 13 Dec 2022 11:04:17 GMT

Try using this.

Total Visit = calculate (sum('Couts Piano 2'),ALL([Total Server call])

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Re: Get the sum by month in columns

Ludovicooo — Tue, 13 Dec 2022 14:08:12 GMT

Hello shreyamukkawar

PREVIEW

Thank you for your answer

Unfortunately not work. "

The SUM function only accepts a column reference as an argument.