The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, I want to use one of my parameters result in a new calculation, but instead, I am always getting the formula and not the value itself. Does anyone know how to select only the result and not the formula? Thanks
hi @Calouro
Essentially, Parameter is just a formula that returns a value.
so you could nest it into measure expression not just add it in the end of formula
For example:
Measure = SUMX('Table',[Qty]+[Parameter Value])
Measure 2 = SUMX('Table',[Qty]) +[Parameter Value]
Result:
If not your case, please share a simple sample pbix file and your expected output.
Regards,
Lin
Hi, lin,
thank you for your answer, it is valid and got the point. The parameter can be used or not depending on the purpose.
I believe I have not explained myself correctly the first time. When I said parameter I should have said measure.
So, I have a measure that has a DIVIDE formula inside and I want to use the result it gets in another formula and not the formula itself. Is this possible?
Example below:
Measure1 = DIVIDE(('table1'[companyx OPEX] - [measure2]) ; SUM('table1'[cost1])) <=> Measure1 = 50
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
32 | |
20 | |
19 | |
15 |
User | Count |
---|---|
44 | |
36 | |
32 | |
23 | |
23 |