Forum Discussion
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...
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.
Thank you all for your help. I have found an error relating to a linked table that is causing multiple values in the Has Exception field so SelectedValues is returning a blank. I will need to work out where this iem is used and rebuild the model.