Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 :
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
The SUM function only accepts a column reference as an argument.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |