empty value in matrix

[Anonymous]

gg

I want to create a custom column that when standard frequentie is empty and gewenste frequentie is not empty then 1 else 0. But when i write a query i cannot select the empty value?

but i can't seem to get the dax right. the frequenties (standaard and gewenst) come from different tables and they share parameter as dimension.

[v-xuding-msft]

Hi @Anonymous ,

I create a sample using two ways to implement it. You can reference it and modify yours.

Create a calculated column

Column = IF(Table1[standaard ] = BLANK() && RELATED(Table2[gewenst])<>BLANK(), 1,0)

Create a measure

Measure = IF(MAX(Table1[standaard ]) = BLANK() && MAX(Table2[gewenst]) <> BLANK(),1,0)

Best Regards,

Xue Ding 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

When i create the measure i only get 0's and my data gets filtered?

Is there something wrong with my relationship?