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 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
 )
lorenz0210's avatar
lorenz0210
Helper I
3 years ago

Hi All, 

 

I am having the same issue and fairly new to dax. I am trying show the numbers based on the selected option in slicer and I am not getting any luck. 

 

So far, here is the dax that I have but incomplete: 

 

REGION Exp. Landing % vs 2023 Commit Filter =
VAR _selectedValue = SELECTEDVALUE('2023 Attainment Details Back Up'[User TP Selling Role])
RETURN
CALCULATE(([ATT GRID OVERALL S + V]+[SUM of 80% SFDC Projection]+[REGION Weighted Pipeline]),'2023 Attainment Details Back Up','2023 Attainment Details Back Up'[User TP Selling Role])
)