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,
As I didn't get any traction with my previous question, I'm trying to build my percentage calculation inside the report builder directly.
This is my table:
In the "%" column, I would like to create a simple expression that divides the value under the first "Users" column by the value under the second "Users" column.
How do I reference those two cells in an expression?
If I copy the content of the cells I get this (which makes every value 100%):
If I assign a name to the cells in the Text Box properties as below and then I use those names in the expression, I get another error:
And the same happens if I assign a label.
How can I reference these two cells to build a calculation in the report builder? Or, how do I declare those values?
Thank you in advance for your suggestions.
Solved! Go to Solution.
What expression are you building for the textbox names?
It should be like :
=ReportItems!CountofUsers0.Value/ReportItems!CountofUsers1.Value
eg in this report :
In Variance column I have put below expression and that works fine :
=ReportItems!Sales.Value/ReportItems!Quota.Value
What expression are you building for the textbox names?
It should be like :
=ReportItems!CountofUsers0.Value/ReportItems!CountofUsers1.Value
eg in this report :
In Variance column I have put below expression and that works fine :
=ReportItems!Sales.Value/ReportItems!Quota.Value
Fixed!!
Thank you SO much!
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 |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |