Keep null rows after applying a measure

[soldous]

I have a table where for some columns in a row null values can appear and it is wanted. But when I add a simple SUM measure to this table null records are completely filtered out. Is there any way how to apply measure only for rows where there is a value but keep empty rows as well?

[tamerj1]

Measure =
VAR Clculation =
"your sum function"

VAR Result =
IF ( ISBLANK ( Clculation ),

"",

Clculation
)

RETURN

Result

you can replace "" with 0

[amitchandak]

@soldous , Try the option in visualization pane - Show item with no data or add +0 to you measure

[soldous]

Show items with no data is not applicable because in some columns I don't want nulls but is some columns I do. Show items with no data shows all blanks.