Forum Discussion

Yossi16's avatar
Yossi16
Regular Visitor
3 years ago
Solved

SELECTEDVALUE Question

Hello, Is it possible to return a table with the filter of the SELECTEDVALUE function? I tried to do it with a calculated table, but it won't let me. Additionally, I attempted to use a measure, but ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Yossi16 

    I guess what you want to achieve is when you select either Roni or Sami the table will be filtered down to only both rows because they both share the same School. 
    There are a number of methods to accomplish this however none of them can be a calculated table as calculated tables/columns do not interact with the filter context. Therefore, I would suggest to simply have a disconnected table of the names. The you can create a filter measure that you can place in the filter pane of the table visual and  select "is" 1 then apply the filter

    FilterMeasure =
    INT (
    SELECTEDVALUE ( 'Table'[School] )
    IN CALCULATETABLE (
    VALUES ( 'Table'[Scoop] ),
    'Table'[Name] IN VALUES ( Names[Name] ),
    ALLSELECTED ()
    )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Yossi16 

I guess what you want to achieve is when you select either Roni or Sami the table will be filtered down to only both rows because they both share the same School. 
There are a number of methods to accomplish this however none of them can be a calculated table as calculated tables/columns do not interact with the filter context. Therefore, I would suggest to simply have a disconnected table of the names. The you can create a filter measure that you can place in the filter pane of the table visual and  select "is" 1 then apply the filter

FilterMeasure =
INT (
SELECTEDVALUE ( 'Table'[School] )
IN CALCULATETABLE (
VALUES ( 'Table'[Scoop] ),
'Table'[Name] IN VALUES ( Names[Name] ),
ALLSELECTED ()
)
)

  • Yossi16's avatar
    Yossi16
    Regular Visitor
    3 years ago

    Great! Thank you.