Hello Everyone,
I'm facing to an issue, for a custommer, I need to build a report to publish to the web
So I created a migrate according to the business rules, and then I added a new visual calculation for my running sum
After that, I made my test in Power BI services, everything is working smoothly but once I published it to the web, disaster, my visual doesn't work anymore...
According to my investigation, New visual calculation is not supported with publish to the web...
So I'm trying to create a measure for this running sum, but it is not working
I have many measure, but I will share with you probably the easiest.
The chart I need to build looks like:
But when I tried to build my running sum, it is retuning something like:
I look like similar, but it is not (as you see the unit are not the same)
So this the look and feel of my measure:
AVGMeasure=
RunningSum =
My visual, is using Date (as X-axis), Country in the legend, and the only external filter I'm using is Source Date, I tried a lot of things, but nothing seems to work 😞
Any idea of what I'm doing wrong ? or How can I debug this measure?
Or is there a way to use calculation visual with publish to Web ?
Many thanks in advance for your help
Hi @Cookistador
Apply a sumx to your average measure than apply a calculate to it.
RunningSum =
VAR MaxDate =
MAX ( 'Dates'[Date] )
RETURN
CALCULATE (
SUMX (
ADDCOLUMNS ( SUMMARIZE ( Dates, Dates[Date] ), "@avg", [AVGMeasure] ),
[AVGMeasure]
),
Dates[Date] <= MaxDate
)
AVGMeasure =
AVERAGEX (
SUMMARIZE (
Data,
Data[Geo],
"AvgAmount", CALCULATE ( AVERAGE ( Data[Revenue] ) )
),
[AvgAmount]
)
Note: I used a separate dates/calendar table.
Helllo Everyone,
I made a small cleaning with my value
For example, for irelande, I need to get the following visual:
Or in term of table, I need to get something like:
You can find the sample here:
And this is the measure I created I would like to make the running sum:
AverageShare =
AVERAGEX(
SUMMARIZE(
DataSample,
DataSample[DisbursementId],
DataSample[Type Funding],
"AvgAmount", AVERAGE(DataSample[Amount])
),
[AvgAmount]
)
Once again,
A huge thank for your help
Using the same measures i provided, this is what i get. You need to specify in your sample dataset the column names. Which one do we use? And I don't think there is an amount there.
Hi @Cookistador
Apply a sumx to your average measure than apply a calculate to it.
RunningSum =
VAR MaxDate =
MAX ( 'Dates'[Date] )
RETURN
CALCULATE (
SUMX (
ADDCOLUMNS ( SUMMARIZE ( Dates, Dates[Date] ), "@avg", [AVGMeasure] ),
[AVGMeasure]
),
Dates[Date] <= MaxDate
)
AVGMeasure =
AVERAGEX (
SUMMARIZE (
Data,
Data[Geo],
"AvgAmount", CALCULATE ( AVERAGE ( Data[Revenue] ) )
),
[AvgAmount]
)
Note: I used a separate dates/calendar table.
Thank you for your reply
I tried it, but it is not working 😞
I get the right value, but when I tried to build the chart, it is not retuning the right figures
I get:
But I would like to get something like
If you want, I share a sample dataset to give you a clear dataset to understand what I want to acheive
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
