Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter Table based on Slicer Selection

  Hi,   I've got a table that I want to filter based on what a Slicer selection returns.   The context is that I have a slicer table that looks like this: MIN VIEWS 100 150 200 ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous add measure as below and in table visual, drop product and this new measure, you will have solution

     

    Views Total = 
VAR __selectedValue = SELECTEDVALUE( Table2[MinViews] )
RETURN 
CALCULATE( 
SUM( Table3[Views] ), 
Table3[Views] >= __selectedValue
 )
Anonymous's avatar
Anonymous
Not applicable
7 years ago
parry2k wrote:

Anonymousyou cannot use slicer value in calculatetable, you need to create measure and use that in a table visual to show the data.

Hi Parry,

 

thanks for your reply.

 

Unfortunately I do not quite understand what you mean with creating a measure and using that in a table visual.

 

I just created a Measure that gives me the selected views, and tried using that as a filter instead - it didn't work either. Can you explain a bit more in depth?

 

Thank you for your help!

 

Leon

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous it will be much easier to provide an answer if you post sample data with expected output.