Forum Discussion
vsslasd1
Helper III
Helper IIIDAX Table with a variable based upon a selected value in a silicer
I have a DAX Table defined as follows: JCTransactions =
var JCType=IF(NOT ISEMPTY(vwJCTransactionsRev2),SELECTEDVALUE('ProjectCalc'[Calc Method]))
var JCProject =
SELECTCOLUMNS(vwJCTransactionsR...
PaulOlding
Solution Sage
Solution SageCalculated tables aren't dynamic based on slicer selections. They're populated on data refresh and don't change after that.
vsslasd1I have used the slicer in formulas which do recalculate in calucated tables. This one is not working the same way.
Using the SELECTEDVALUE function in DAX - SQLBI