Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using a (data) parameter in measures, to change behaviour of buttons

Hi all,   After trying in all sorts of ways and looking at a lot of other forum posts, I still could not get it to work, so here's my question!   We deliver reports to a number of customers, some...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi Anonymous ,

     

    I think you may need to pull your parameter values into their own queries to be able to reference their values in measures.

     

    Try creating a blank query in Power Query and coding it like this:

     

    let
  Source = #table({"paramCustomer"}, {{#"CustomerName"}})
in
  Source

     

    This should give you a single-value table to reference in calculations.

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

I think you may need to pull your parameter values into their own queries to be able to reference their values in measures.

 

Try creating a blank query in Power Query and coding it like this:

 

let
  Source = #table({"paramCustomer"}, {{#"CustomerName"}})
in
  Source

 

This should give you a single-value table to reference in calculations.

 

Pete

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you!