Forum Discussion
empty value in matrix
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...
v-xuding-msft
Community Support
Community SupportHi 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.
When i create the measure i only get 0's and my data gets filtered?
Is there something wrong with my relationship?