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:

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

parry2k Thats a good Idea. So I have this table:

 

MIN VIEWS
100

150

200

250

 

and this table.

Product IDViews
1500
2300
3450
430
520

 

My expected Output is a new table, that dependant on some form of selection tool, gives me this output:

 

 

 

Product IDViews
1500
3450

 

 

Thanks,

Leon

 

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
 )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    parry2k wrote:

    Anonymousadd 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 That works quite well, thank you. However when I add any other columns, new Products come into the table. Any chance I can prevent that? So then the output looks like this:

    Product IDViews TotalPrice
    150050
    2 60
    345010
    4 22
    5 12

     

    I don't want 2,4,5 in the table though, because I'm working with and visualizing the numbers...

     

     

    Thanks,

    Leon

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        parry2k wrote:

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

        Thank you parry!!

  • 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])
    )