Hello all,
I am trying to create a new table using the following but it returns a blank table.
New Table = FILTER(Data_Validation_2,Data_Validation_2[Valid] = SELECTEDVALUE(Data_Validation_2[Valid],-1))
Data_Validation_2[Valid] contains three values [6,7,8]
I have a slicer with Data_Validation_2[Valid] as the Field and 6 selected.
If I directly use 6 in the command rather than selectedvalue I get a table that only has 6 in the Valid column.
New Table = FILTER(Data_Validation_2,Data_Validation_2[Valid] = 6)
To prove to myself that I am not crazy I created a new measure and added it to a Card and got the expected result 6.
New measure = SELECTEDVALUE(Data_Validation_2[Valid],-1)
Any help would be greatly appreciated,
Steven
