Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |