Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ludovicooo
New Member

Get the sum by month in columns

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
2 REPLIES 2
Anonymous
Not applicable

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!

Hello shreyamukkawar

PREVIEW
 
Thank you for your answer
Unfortunately not work. "
The SUM function only accepts a column reference as an argument.
 colonne.PNG
 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.