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 Everyone,
I have a column TCO% which has values like 5,10,15,20....till 95.
I have a measure Base% which again has values like 5,10,15,20....till 95. I am using this measure in a slicer as a Dropdown so that user can select a single value. I want to subtract (TCO% - Base%)/100 (Whatever Base% user selects).
Example, if user selects Base % 30,
Then, TCO % should evaluate to (5-30)/100
(10-30)/100
(45-30)/100
(95-30)/100 I will use these values for further calclations
Idea is to make Base % dynamic - user selective and calculates the result. For this, I have created another Measure,
Result = (TCO % - Base%)/100
Since Result is a measure type and Base% is already a measure, I cant use TCO% directly as it is a column. If I use VALUES function, it says multiple values were supplied when single value is expected.
Solved! Go to Solution.
Hi @shubh_kush ,
Please try to update the formula of measure [Result] as below and check whether it can return your desired result:
Result =( MAX ( [TCO %] ) - [Base%] ) / 100
If the above one is not working, could you please provide the formula of measure [Base%] and the screenshots of related visuals? Thank you.
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi @shubh_kush ,
Please try to update the formula of measure [Result] as below and check whether it can return your desired result:
Result =( MAX ( [TCO %] ) - [Base%] ) / 100
If the above one is not working, could you please provide the formula of measure [Base%] and the screenshots of related visuals? Thank you.
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |