Forum Discussion
Advocate IIEmpty selectvalue eve if is not empty
Hi SebaSpotti
Calculated tables are evaluated with data refresh, so SELECTEDVALUE will not work this way. (I assume your intention was that when you change the slicer selection for Month, the calculated table recalculates with that month, which is not possible)
See these previous threads for proposed workarounds:
https://community.fabric.microsoft.com/t5/Desktop/Calculated-Table-using-SELECTEDVALUE/m-p/911501
https://community.fabric.microsoft.com/t5/Desktop/Using-SELECTEDVALUE-with-Calculated-Table-workaround/td-p/1362430
Super UserHi SebaSpotti ,
The issue with your code arises because SELECTEDVALUE(MonthDate[Month]) is returning blank in the context where the calculated table is being evaluated. This happens because a calculated table is evaluated in a global context, not in the context of a specific row or filter.
Take off SELECTEDVALUE function and keep only something like this:
VAR ___Date = MonthDate[Month]
If this help you, please consider to accept this reply as solution and give a Kudo.
thannk you