Forum Discussion

Mark_A12's avatar
Mark_A12
Regular Visitor
1 year ago
Solved

SelectedValue producing odd results

I have a report detailing runners times some people have restricitons, i.e. parent with a child these records show as having an exception, Has Exception = Yes.  I want to identify those with an excep...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    In your example, I can see only one Has Exception column so I dont know which is which -whether that is from dim_runner or dim_staff. What I would do though is to create measures that returns the SELECTEDVALUE of those columns - they might be returning blanks or values other than what are expected - and then add those measures to the viz

     

    HasException_Runner =
SELECTEDVALUE ( 'dim_runner'[Has Exception] ) 

HasException_Staff =
SELECTEDVALUE ( 'dim_staff'[Has Exception] )

     

    Plese note that if SELECTEDVALUE sees more than one distinct value in the current row context, it will return blank. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Mark_A12 ,

Just checking that you mentioned that you found the issue was due to a linked table causing multiple values in the Has Exception field, and that you were planning to rebuild the model.

Were you able to get that sorted out? If yes, we’d love to hear how you resolved it, it could help others who might run into a similar challenge.


Also, huge thanks again to all the super users mdaatifraza5556 , Rahul_2645  and danextian . Looking forward to your update.

Thanks,
Akhil.