dynamically filter report based on measure

[Anonymous]

Hi,

Im looking for a way to dynamiclly filter my report based on a measure . the measure is calculated on the fly, according to user's selection and I want to filter a table to present just records in which the value of a specific column equals the measure.

Thanks

Aviv

[Anonymous]

Hi,

You can make a 'What If Parameter' in Modelling>What If>New Parameter. This creates a generated series and a slicer which updates according to user-input that you can use to filter

Thanks

[Anonymous]

Hi,
Is that possible when using connectlive mode?

[Anonymous]

Don't think it's possible in direct query mode as this method generates a table. 

What you could do is create the value range column in the backend (SQL table with range of values) and connect to it?