Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 i can't seem to get the dax right. the frequenties (standaard and gewenst) come from different tables and they share parameter as dimension.

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

      Is there something wrong with my relationship?