Forum Discussion

souvik900766's avatar
souvik900766
Helper IV
5 years ago
Solved

Selectedvalue returning blank

Hi ! When I am using two selectedvalue with filter then my value is coming blank. Refer Pic:- Just check selected 4 measure... it is showing blank. When I will select other companies othe...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Well, you should drop the [1_Total Value] measure on the canvas and see what it returns. I'm sure it returns BLANK but it should not. Revise this measure. On the other hand, if it does return a value, then it means your comparisons under IF do not do what you think they do. Maybe your literals are not correctly written? Be mindful of non-printable characters... for instance...

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Well, you should drop the [1_Total Value] measure on the canvas and see what it returns. I'm sure it returns BLANK but it should not. Revise this measure. On the other hand, if it does return a value, then it means your comparisons under IF do not do what you think they do. Maybe your literals are not correctly written? Be mindful of non-printable characters... for instance...

souvik900766's avatar
souvik900766
Helper IV
5 years ago

Hi !
Anonymous 
This lines of yours made it work !
"you should drop the [1_Total Value] measure on the canvas and see what it returns. I'm sure it returns BLANK but it should not."😂
Thank you so much !