Nice, glad to hear you managed to find your way through, good job !

Hi again,

Sorry to say, but another problem came up when implementing the working solution today with my 100 thousands of rows with real data.

This fails in Excel 2010 production: TotalAmount2:=IF(ISBLANK(SUM ( Tabell1[Amount] ));"";SUM ( Tabell1[Amount] ))

The parameters ;""; obvoiusly doesn't like to cooperate in the Amount measure.

I've also tried changing "" to BLANK(), but running totals doesn't seem to work with blanks either.

The difference might have to do with Excel Power Pivot versions, as I'm using 2010 in production, and newer Excel 365 in my development environment.

Uploading a mp4-fil (video) here showing this actually works just fine in Excel 365, and the original Excel file for testing yourself (v5).

I'll keep on working with it, searching a way around. Still using DAX formulas I see could be useful here.

Trond

You should update first the power pivot add-in. For this, the only way is to download again the add-in and install it.