Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I would like to dynamically change a value based on a percentage that is selected from a dropdown list. The scenario is that there is a maximum revenue generated per year but then the user has the option to select a percent from a dropdown and have the revenue numbers reflect that. In other words, if the max revenue generated is $1,000,000 for each year, then a user could select "25%" and then the revenue changes to $250,000 for year 1. I'm thinking I could pull this off with SELECTEDVALUE in a measure but I'm not entirely certain. I had used SUMX to get my revenue numbers per year in a table but I don't know how to incorporate the percentage aspect. Is this possible?
Thank you!
Solved! Go to Solution.
Hi @JLambs20 ,
According to your description and screenshot, it seems that the fields used for Year slicer and % slicer are from other tables, so I have create a data sample like:
Original Table:
Add two tables:
Then please try:
Measure =
var _selectYears= SUMX(FILTER('Table',[Year] in ALLSELECTED('Select Year'[Year Only])),[Revenue])
var _selePer= SELECTEDVALUE('Select %'[Value])
return _selectYears * _selePer
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JLambs20 ,
According to your description and screenshot, it seems that the fields used for Year slicer and % slicer are from other tables, so I have create a data sample like:
Original Table:
Add two tables:
Then please try:
Measure =
var _selectYears= SUMX(FILTER('Table',[Year] in ALLSELECTED('Select Year'[Year Only])),[Revenue])
var _selePer= SELECTEDVALUE('Select %'[Value])
return _selectYears * _selePer
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JLambs20 ,
You can use a disconnected table that holds the percentages. This can be done by using the Enter Data function or through DAX. You can use GENERATESERIES function to create a table that holds the percentages - example:
Percent Parameter =
VAR __BASE_TABLE =
GENERATESERIES ( 0, 1.001, 0.01 )
You can then create a measure to multiple a measure based on the value from another table.
Pct Revenue =
SELECTEDVALUE ( 'Percent Parameter'[Value] ) * [Revenue Measure]
Proud to be a Super User!
Hi @JLambs20 ,
This might help. https://drive.google.com/file/d/1MI29v8PazERHYjgXBjN6Yd873SIG7MFW/view?usp=sharing
Did I help you today? Please accept my solution and hit the Kudos button.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |