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.
I am currently trying to build a dynamic budgeting tool for an energy company. With oil prices being so low currently this company would like to have the ability to "turn off" a well to help determine what is economic and what is not. So if a well is selected in a slicer I would like to set its value to zero while keeping the others the same. Is it possible to do that through a measure?
Thank you in advanvce!
Solved! Go to Solution.
Hi @TheCAKurtle ,
1. Create a slicer table,put the categories in the column:
2.Delete the relationship between table and the slicer table:
3.Create a measure as below:
Measure = IF(SELECTEDVALUE('slicer table'[category])=SELECTEDVALUE('Table'[Category]),0,'Table'[Ratio])
Finally you will see:
Is the above what you need?
Here is my sample .pbix file you can refer to.
Hi @TheCAKurtle ,
1. Create a slicer table,put the categories in the column:
2.Delete the relationship between table and the slicer table:
3.Create a measure as below:
Measure = IF(SELECTEDVALUE('slicer table'[category])=SELECTEDVALUE('Table'[Category]),0,'Table'[Ratio])
Finally you will see:
Is the above what you need?
Here is my sample .pbix file you can refer to.
Not sure I got, But What if, Measure slicer or Bookmark can help
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Yes.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
It is really tough to say without seeing the data but maybe something along the lines of:
Measure =
VAR __Selected = 'Table'
VAR __UnSelected = EXCEPT(ALL('Table'),__Selected)
RETURN
SUMX(__UnSelected,[Column])
So basically, you grab everybody in context within the slicer (__Selected). You then get everyone (ALL) and then filter out __Selected using EXCEPT. Then you just SUMX across __UnSelected for some Column. And you have effectively wiped out any impact from the "selected" wells, in effect, setting their values to zero.
Thanks for the quick reply. I am using this calculation to feed into several others so from this I get a ratio for how much production a particular well contributes which is then used to allocate costs. When a wells production goes to 0 I would like those ratios to be recalculated so that costs can be reallocated. I don't think this solution will work for that... Or am I mistaken?
I have no idea if it will work or not because I have zero sense of the data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |