Selectedvalue text not working in a filter where hard-coded text does

Question

Hi!&nbsp;I'm trying to filter a table by name.&nbsp; I'm using a calculate statement and filtering on a Time Intelligence table that's set up by weeks; that part of the filter works.&nbsp;What isn't working is when I try to add a filter for employee name.&nbsp; I've created a duplicate of my original table, deleted the columns, and removed duplicates to generate a list of unique names.&nbsp; I created a slicer that let's me select a name, and I created a measure:Selected Employee= selectedvalue('Employee Table'[Employee]).&nbsp;I've tried comparing the values in a filter with the measure directly and via a set variable and it isn't&nbsp;working.&nbsp; If I hard code in the Selected Employee, e.g. Filter(Worklist,Worklist[Employee]="Fred Flintstone"), the values update.&nbsp; Below are the current column formulas that I feel should be working.&nbsp; Can anyone point me to what I'm missing?Comparing to a variable:Name Count = var EmployeeName = [Selected Employee] ReturnCalculate(count(Worklist[Project Name]),Filter(Worklist,Worklist[Employee]=EmployeeName),DATESBETWEEN(Worklist[Creation Date].[Date],('Time Intelligence'[Date].[Date]),('Time Intelligence'[Date+6].[Date])))Comparing to a measure:Calculate(count(Worklist[Project Name]),Filter(Worklist,Worklist[Employee]=[Selected&nbsp;Employee]),DATESBETWEEN(Worklist[Creation Date].[Date],('Time Intelligence'[Date].[Date]),('Time Intelligence'[Date+6].[Date])))Many thanks!

sandeephijam · Answer

Hi There,&nbsp;See by Providing the Alternate Result as well.SELECTEDVALUE(&lt;columnName&gt;[, &lt;alternateResult&gt;])&nbsp;Or else you can also try the HASONEVALUE( ) function as well&nbsp;IF(HASONEVALUE(&lt;columnName&gt;), VALUES(&lt;columnName&gt;), &lt;alternateResult&gt;).&nbsp;Use SELECTEDVALUE instead of VALUES in DAX - DAX | Microsoft Learn&nbsp;

brianhawley · Answer

Thanks for looking at this.&nbsp; The generated names table has no duplicate values, so there isn't an alternate result.&nbsp; I tried both suggestions for good measure and there was no effect.&nbsp;If I place the [Selected Employee] measure into a Card visual, the single name appears and changes based on what I've selected in the slicer, which is set to single selection.

guirikiki · Answer

Hello,I have the same problem. Do you find a solution ? Thank you.

sanjyot_firke · Answer

Was there any solution found to this issue? We are facing the same issue.

Forum Discussion

Selectedvalue text not working in a filter where hard-coded text does

4 Replies

Related content

SELECTEDVALUE not working

SelectedValue Measure DAX not working

Hard coded days as working days column

Selectedvalue() doesn't work when multiple options are selected

Selectedvalue