Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 of which have a Basic subscription and some of which have a Plus subscription. How I would like it to work:
My goal is to create a measure which looks at the parameter value for CustomerName I have set, and then finds the subscription name in the Subscriptions-table. Using that measure, I can then build different other measures that can e.g. determine what text to display or to which destinations buttons should go.
However, I can't get it to work: I cannot 'extract' the parameter value in a measure. How should this be done?
Hereby you find a couple of screenshots to clarify.
I hope you can help, thanks in advance!
Regards,
Asjen
Solved! Go to Solution.
Hi @Asjen ,
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
Proud to be a Datanaut!
Hi @Asjen ,
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
Proud to be a Datanaut!
Thank you!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |