How to calculate Total of a measure including blanks

[AmineGatou]

Hello everybody so I have this problem right here 

I want the total of GapVsMedian to include the blank values also 
Expected Value -429 
Got Value of -121 (-63-58)

How can I include those -77 in my measure? 

[Anonymous]

Hi @AmineGatou,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[AmineGatou]

hi @Anonymous , sorry for late reply i was out of office past days
So basically 

I want those "-77" who are blanks in "Turnover" to be included in the sum calculations

PWBI file in link => SumProblemPwbi.pbix

[johnt75]

Rename your current measure to Individual Gap vs Median then use

Gap vs Median = IF( ISINSCOPE( 'Table'[Customer name]), [Individual Gap vs Median],
var summaryTable = ADDCOLUMNS( VALUES('Table'[Customer name]), "@val", [Individual Gap vs Median])
return SUMX(summaryTable, [@val])
)

[AmineGatou]

@johnt75  Nop it didn't work, it gave me exactly the same thing 

Individual Gap vs Median = IF(HASONEFILTER(Data[Raison sociale]),[TotCA]-[Mediane],SUMX(VALUES(Data[Raison sociale]),[TotCA]-[Mediane]))

GapVSMed = IF(ISINSCOPE( Data[Raison sociale]), [Individual Gap vs Median],
var summaryTable = ADDCOLUMNS( VALUES(Data[Raison sociale]), "@val", [Individual Gap vs Median])
return SUMX(summaryTable, [@val]))