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
 )
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous in visual level filter, in measure , choose great than zero.