SELECTEDVALUE works in Chart but doesn't work in Table

[jeyare]

Hi there,

I'm stuck somewhere, and I can't find the cause.

Background:

1. Table with the name "Population Switch" with a single column "Pop Switch" and two records

    Slicer with Field to the "Pop Switch" column

    The Slicer works as expected. Tested with Card Chart = it shows just the selected value.

2. Second Table. I need to use SELECTEDVALUE to test the "Pop Switch" value from the Slicer selection:

VAR _SelectSwitch = SELECTEDVALUE('Population Switch'[Pop Switch])

 It returns "ERROR":

"A table of multiple values was supplied where a single value was expected."

Tests A.:

I created a Measure:

SELECTEDVALUE('Population Switch'[Pop Switch])

Works as expected. The Card Chart shows just the selected value.

but

when I use SELECTEDVALUE with the Measure within the "Second Table" I got the same ERROR:

"A table of multiple values was supplied where a single value was expected."

Tests B.:

The Second table, New Column:

VALUES('Population Switch'[Pop Switch])

I got the same ERROR:

"A table of multiple values was supplied where a single value was expected."

I'm stuck somewhere, and I can't find the cause.
Thanks for your help,

J.

[amitchandak]

@jeyare , you can not use selected values from a slicer in a table

way to create a table is

new table = values(Table[Column])