Calculated column based on slicer selection

[JSR]

I know slicers values can't change Calculated columns value, but looking for a workaround for my scenario.

I have a merge table From Person and Objectives.

If the merge table has Objective ID -> Calculated column to Yes

I need now to add a filter to the calculated colum from the selected value of a Sync Slicer

I dont think I have any other laternative but to use a calculated colum, isn' it?

How could add the extra filter I need into the calculated colum?

Thanks

[Sujit_Thakur]

Dear @JSR ,
Please try to explain more , i am sure i can help you in this .
what i understood is you want to use a synced slicer to filter the calculated column .
If you want power BI to recalculate when you change slicer selection then you will have to use calculated measures.
try writting me what do you actually want , I will be happy to help

I expect a kudo by pressing thumbs up button from below and if this post brought you near to your solution please do accept this post as solution
Regards ,

Thakur Sujit

[JSR]

thanks @Sujit_Thakur

see my last reply, I think have detailed well now.

[amitchandak]

@JSR ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[JSR]

Sure thanks.

I have this calculated colum: 

Performace Objective Set = if('Merge Performance'[Performance Objectives Id] <> "",  "Yes", "No")

And I need to include another condition based on the selected value of a Slicer, but adding the following in bold doesnt change the value of calculated column.

Performace Objective Set = if('Merge Performance'[Performance Objectives Id] <> "" && SELECTEDVALUE('Performance Objectives'[Year], "2020") = 'Merge Performance'[Performance Objectives Year] ,  "Yes", "No") 

[Sujit_Thakur]

Dear @JSR ,
Please try and let me know 

Performace Objective Set =
                                      var Alpha=Merge Performance'[Performance Objectives Id]
                                      var Beta = 'Merge Performance'[Performance Objectives Year]
                                      Return IF((NOT(ISBLANK(Alpha))  && SELECTEDVALUE('Performance Objectives'[Year], "2020") == Beta ,   "Yes", "No")
I hope it works 
orelse will try again to help , till you reach your solution

I expect a kudo by pressing thumbs up button from below and if this post brought you near to your solution please do accept this post as solution
Regards ,

Thakur Sujit

[JSR]

Thanks again @Sujit_Thakur for your reply

I had to add ) at the end of your sentence

Not sure why I'm getting Operator or expression '( )' is not supported in this context.

[Sujit_Thakur · Accepted solution]

Dear guest, @JSR

Try to remove the parathesis'('

Before No and also delete one after alpha from the return statement

Check and let me know

If you decide please accept as a solution and do not forget to give congratulations

Best regards

Sujit

[Sujit_Thakur]

Dear @JSR 

Did this helped ???

If yes please accept as solution so that it may help our family

If it brought atleast a bit closer atleast try giving kudos to keep solution providers motivation

Regards

Sujit