Variable input slider with table

[jalanhart]

I'm trying to create a sheet where there's a slider that adjust a table based on the slider.

My table has a mix of dimensions and measures, and one of those is a measure of months of supply (calc of QTY on hand / monthly avg usage). I created a variable and a slider, but I can't figure out how to make the table adjust accordingly to only show records where the months of supply are greater than or equal to the number of months in the slider. 

How do I connect the slider to the table? 

[jalanhart]

OK I think i might be getting somewhere finally! I had tried the some aggregating before with no success but I tried --  sum(aggr(If([MONTHS OF SUPPLY]>=$(vMTHSSUPPLY), [VALUE ON HAND]),CONTRACT, COMPONENT_PART))   

I put that in a KPI and that seems like it's working closer to how I need it. I will try to put that in my table in later (it's midnight here) and let you know how it works!

Thanks again!

[jalanhart]

so far this seems to be working like I need so thanks for your help!

about the slider, when you move the slider and it filters data shown in a table for example, is it actually filtering the data that's loaded like a filter visual would be doing? So the slider manipulates one field in table A, can that action filter the data in table A to adjust the data in associated table B ? 

[rubenmarin]

Hi, I think that the only way to do that is to add the condition in each expression in both tables, or use a calculated dimension that limits the dimension values and uncheck the option to show null values in that dimension.