Selectedvalue returning blank

[souvik900766]

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 other than DEF it will return Blank..
Power Bi file link:-
https://www.dropbox.com/s/7udxm65jc7i6u0k/Dummy.pbix?dl=0

[daxer-almighty]

OK. I've seen the file. First, there's no entry in the key table for DEF and ABC TM together. So, what you get is technically correct (for all selections). Your "problem" stems from the fact that you're making the same mistakes like so many other people new to PBI: You are not following Best Practices of dimensional modeling. If you create a proper star schema, this issue will be gone. Be aware that [1_Total Value] is indeed BLANK for the combination of attributes we're talking about.

Now, if there is no combination of attributes A and B in a table, then even though you have value A in a slicer (coming from the same table!), SELECTEDVALUE(...) will return BLANK if value B is in the current context (this is exactly what's happening in this case). If you create proper dimensions (and you should always do it even in quick-and-dirty models), then the function will return the value selected as expected (this is another thing to look out for when working with the INCORRECT one-table models and is a manifestation of the infamous auto-exist "feature" which I call "a bug"). So, in order for your SELECTEDVALUE(...) to return what's really been selected in a slicer, you have to follow the rules of proper dimensional design: fact tables hidden, only dimensions exposed for slicing and dicing.

Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

[Anonymous · Accepted solution]

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]

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 !