A problem with martix total

Islam , as mention at the begining, the reason for this os because in total row the difference is in minus and there is no result. The logic is as on detail row, if openings<expense, return 0.
So in order to have "sum" in totals, you need to use IfHasOneValue.
Attached file.

Example:

TotalPayback New =

var _filterArea = FILTER('Table','Table'[Openings]>'Table'[Expenses])

RETURN

IF(HASONEVALUE('Table'[YearMonth]),

IF([TotalOpenings]-[TotalExpenses] >0,[TotalOpenings]-[TotalExpenses]),

SUMX(_filterArea,'Table'[Openings]-'Table'[Expenses])

)

 

Regards,
Nemanja Andic

Attached file.