Forum Discussion

Sudharsanan's avatar
Sudharsanan
Helper III
4 years ago

Global variable Declaration for complete report

Hi All,

 

Is it possible to create a Variable which can be used for complete Power BI report?

 

Can we make the varible filter based on selected values?

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Sudharsanan , you have all a page(report level filter) in the filter pane. But you can use only a column there, you can not use a measure there

    • Sudharsanan's avatar
      Sudharsanan
      Helper III
      4 years ago

      amitchandak my case is like i have a value set to a Variable while creating a measure and i wanted to use the same variable for creating different measures. is that possible?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Sudharsanan ,

     

    Sorry for that the information you have provided is not making the problem clear to me.

    If you want to get dynamic values as measures, please try Slicer and use the following syntax:

    Min = MIN('Numbers'[Parameter])

Max = MAX('Numbers'[Parameter])

    Output:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.