DAX to switch value based on selected value

[aprilbanana]

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%.

[bhanu_gautam]

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