Calculated column not showing blank rows

[Anonymous]

Hi
I created a calculated column using following Dax
Value= VAR
Cal1=if (isblank(table1[date field1))|| ( isblank ( table 1[ date field 2])), BLANK(),Datediff( table1[field 1],table1[date field2], day))
VAR
Cal2= same as above with date field 2 and date field 3
VAR
Cal3=cal1-cal2
RETURN
If(isblank(Cal1)|| (isblank(Cal2)),BLANK(),Cal3)
Problem: when I am pulling this Value column in table visual, along with field 1,2,3; it is not showing any blank rows. So only showing rows where Value column has values. When I take Value column out, table shows all rows.
I could not find ‘show data within value’ option also
What I am doing wrong? Please help.
I tried creating measure also but getting same problem.

[vivran22 · Accepted solution]

Hello @Anonymous 

You may try this:

From the drop down option of ID column > Select Show items with no data

For this, I have created the calculated column as per your scenario:

Column = 

VAR Col1 = IF(
            ISBLANK(Sheet1[Date 1]) || ISBLANK(Sheet1[Date 2]),
             BLANK(),
             DATEDIFF(Sheet1[Date 1], Sheet1[Date 2],DAY)
            )
VAR col2 = IF(
            ISBLANK(Sheet1[Date 2]) || ISBLANK(Sheet1[Date 3]),
             BLANK(),
             DATEDIFF(Sheet1[Date 2], Sheet1[Date 3],DAY)
            )
VAR Diff = IF(
    ISBLANK(Col1) || ISBLANK(col2),
    BLANK(),
    Col1 - col2
)
RETURN
Diff

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

[Anonymous]

Thanks a lot.
Super silly me! I was looking for show items with no data for value field only , not other fields.
Seeing your ID field made me realize that
Thanks
Thanks

[amitchandak]

On the dimension you have used try