Changing a column value of a specific row based on another column using slicer/button

[Kolumam]

I have the below sample table.

Name	Size	Cost	Year 1	Year 2	Year 3
X	2	3	6	1	5
Y	4	5	20	1	9
Z	3	7	21	4	10

Year 1, Year 2 and Year 3 are calculated using Power Query.

Year 1 = Size * Cost

Year 2 = Cost - Size

Year 3 = Size + Cost

I need to replace the Year 1, Year 2 and Year 3 values for Name Y alone based on a slicer/button. Is it possible?

Year 1	26
Year 2	11
Year 3	10

Expected Output:

When I click a button, the table should change to below:

Name	Size	Cost	Year 1	Year 2	Year 3
X	2	3	6	1	5
Y	4	5	26	11	10
Z	3	7	21	4	10

@parry2k @mahoney19  @parry2k @az38 @jdbuchanan71 @mahoneypat @edhans @harshnathani @v-kellya-msft @MFelix @Ashish_Mathur @BA_Pete @ryan_mayu @kbuckvol @Alexander76877 @Petazo @Mariusz @TomMartens @Greg_Deckler @tjd @Sean @mikstra @AllisonKennedy @EricHulshof @briandpeterson @USG_Phil @vpatel55 @mwegener @v-piga-msft @tex628 @sturlaws @Vvelarde @CheenuSing @MarcelBeug @Zubair_Muhammad @v-piga-msft @danextian @MattAL @MattAllington @roalexan @Alexander76877 @kgc 

[amitchandak · Accepted solution]

@Kolumam , You can check for isfiltered and value of selected column or Both . Assume Year1 is a measure.

New Year One = if(isfiltered(Slicer[slicer]) && SelectedValue([Slicer[Slicer]) = "Y" ,26 ,[Year 1])

Repeat this for year 2 and year 3.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.