how to sum fo the prepared measure in the total

[mic_rys]

Hi, I have a problem with total in my prepared measure, I know that need to user hasonevalue function but my all ideas doesn't work.

My measure:

Fill blank rows 2 =

VAR PrevDate =

MAXX (

FILTER (

ALL ( 'Date' ),

'Date'[Date] < MAX ( 'Date'[Date])

&& NOT ( ISBLANK ( [Fill blank rows first] ) )

),

'Date'[Date]

)

VAR LastValueFill =

CALCULATE (

[Measure1],

FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] = PrevDate )

)

VAR FillEmpty = if( ISBLANK([Fill blank rows first]), LastValueFill,[Fill blank rows first] )

return

IF (

HASONEVALUE ( Clients[Code] ),

FillEmpty

,BLANK()

)

In short, this measure inserts the last values if blank.

Instead of Blank in Total I need a sum of the FillEmpty.

Result:

[amitchandak]

@mic_rys , Change the return like

sumx( addcolumns(summarize( Table, Clients[Code] , 'Date'[Year Month]), "_1", calculate(IF ( HASONEVALUE ( Clients[Code] ), FillEmpty ,BLANK() ))), [_1])

[mic_rys]

@amitchandak 

I tried this way but it doesn't sum correctly:

[amitchandak]

@mic_rys ,

can you simply keep this in return

sumx( addcolumns(summarize( Table, Clients[Code] , 'Date'[Year Month]), "_1", calculate(IF ( HASONEVALUE ( Clients[Code] ), FillEmpty ,BLANK() ))), [_1])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[mic_rys]

@amitchandak 
It's live connection so it not easy to simplify the data but I can show part of the model which is used.

The result of your code is:

[v-shex-msft · Accepted solution]

Hi @mic_rys,

According to the description, it seems like a common measure total level calculation issues.

If that is the case, I'd like to suggest you refer to the following link to know how to handle this scenario.

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[mic_rys]

HI, thanks, it helped somewhat! I added extra measure and now it summarizes well!

Last value by customer with filled values =

var _wynikGrand = sumx(

GROUPBY( Tasks, Clients[Code],'Date'[YearMonth] )

, [Filled values]

)

return

_wynikGrand