Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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 ,
@JSR ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Sure thanks.
I have this calculated colum:
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 ,
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.
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
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