Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

some syntax help

Measure = CALCULATE(view[MC],NOT (ISBLANK(view[CL])), ISBLANK(v_C]))

than I have a new computed column that returns string, but I want to have the count of this new computed column ( view[newcolumn] and add it to the end of my measure, and I am not succesful

thanks 

Need Help

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous

     

    You may try below measure. If it is not your case, please share some data sample and expected output for your scenario so that we could help further on it.

    Measure =
CALCULATE (
    COUNT ( view[NewColumn] ),
    FILTER ( view, NOT ( ISBLANK ( view[CL] ) ) && ISBLANK ( view[v_C] ) )
)

    Regards,

    Cherie