User Profile
MichaelHalling
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Using Slicer as input for a DAX measure ignoring some visual filters
Hi I am trying to replicate with DAX what I can do in Excel. Basically, I need a measure that can lookup some values from a Table based on the hard coded value "Xccy" in the Base Column and a dynamic value provided by a Slicer (retrieved in DAX by SELECTEDVALUE(Selector[CCY])). I want the visual filter for the column "Period" to still be active but ignoring columns "CCY" and "Base" in the Visual. I.e. depending what I choose from the slicer the measure returns differtent values in real time and changes as presented in the tables below. Possible? Help much appreciated.Uso de la lista anidada para filtrar la tabla anidada
En mi tabla principal [FilterListZC] tengo una columna [FilterZC] que contiene listas anidadas y una columna [Selected] de tablas anidadas. Cada tabla anidada en [Selected] contiene una columna [TenorCode] que me gustaría filtrar con los valores de la lista correspondiente en [FilterZC]. He probado varias soluciones, pero ninguno funciona. Aquí está un ejemplo de uno que no funciona: • Table.AddColumn(FilterListZC, "FilteredZC", each Table.SelectRows([Selected], each List.Contains( (r)-> [FilterZC], [TenorCode]))) ¿Es posible? ¿Qué necesito cambiar? ¡Gracias un millón por cualquier ayuda!Using nested list to filter nested table
In my main table [FilterListZC] I have a column [FilterZC] which contains nested lists, and a column [Selected] of nested tables. Each nested table in [Selected] contains a column [TenorCode] I would like to filter with the values in the corresponding list in [FilterZC]. I have tried various solutions but none work. Here is an example of one that does not work: = Table.AddColumn(FilterListZC, "FilteredZC", each Table.SelectRows([Selected], each List.Contains( (r)=> [FilterZC], [TenorCode]))) Is this possible? What do I need to change? Thanks a million for any help!
