Columna calculada que no muestra filas en blanco

[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]

Hola @newcomer

Puede intentar lo siguiente:

En la opción desplegable de la columna ID > Seleccionar mostrar elementos sin datos

Para esto, he creado la columna calculada según su escenario:

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

¡Salud!
Vivek

Si ayuda, por favor márquelo como una solución
Los felicitaciones serían una cereza en la parte superior 🙂

https://www.vivran.in/

Conectar se conecta en 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]

En la dimensión que ha utilizado, intente