Gilles on 25 Jun 2018 00:04:17
For the moment it is, as far as I know, not possible to use a field value in order to refer to a column of a table or a measure by using DAX (a workaround consists in using the switch functions, which works well in simple situations). With the DSUM-function one can however compute a sum in ACCESS on a dynamically defined column which may also depend on a dynamically defined condition. Unfortunately the SUMX-function in Power BI does not allow to do the same.