Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

dynamically filter report based on measure

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

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago
      Hi,
      Is that possible when using connectlive mode?
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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?