Forum Discussion
DAX to switch value based on selected value
Hello,
How do I switch a value in a different column based on the selected value in my dropdown?
For example:
| Name | Result |
| Banana | 0 |
| Grape | 0 |
| Strawberry | 1 |
Apple | 0 |
When i get the average of the result column it'll be 25%. If I choose Banana from my slicer, how do I get it to change the result column to 1?
Results should be:
| Name | Result |
| Banana | 1 |
| Grape | 0 |
| Strawberry | 1 |
| Apple | 0 |
New average should bt 50%.
1 Reply
- bhanu_gautam
Super User
Hi aprilbanana , you can achieve this by using parameters in Power BI
Paramaters can be found under Modelling tab and you can use numeric range and use that in your DAX
