Table of data - measure removes blank columns how to fix?

[Oskar]

I have a table:

Some of the columns in ClosedAt is blank.

I made this measure:

TimeToSolved = AVERAGEX(
    Cases,
    DATEDIFF(Cases[OpenedAt],Cases[ClosedAt],day)
)

When i add this measure to the table i get the expected result.

But all the rows with blank value disapear.

How to keep them but dont give result or 0 as result in the measure?

[_AAndrade · Accepted solution]

Hi @Oskar

Try something like this:

IF ( ISBLANK(Cases[ClosedAt]), "-", 

AVERAGEX(
    Cases,
    DATEDIFF(Cases[OpenedAt],Cases[ClosedAt],day)
)

[audreygerred · Accepted solution]

Right click on OpenedAt in the visualization pane for your visual and select show items with no data.

[_AAndrade · Accepted solution]

Hi @Oskar

Try something like this:

IF ( ISBLANK(Cases[ClosedAt]), "-", 

AVERAGEX(
    Cases,
    DATEDIFF(Cases[OpenedAt],Cases[ClosedAt],day)
)