Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |