nested filter
1 Topic
Nested Filter DAX Query
Would anyone be able to tell me how to fix this DAX Query? It gives me the error: SummarizeColumns() and AddMissingItems() may not be used in this context. The general pattern for writing a DAX query using nested filtering logic (i.e., combining multiple && and ||) without having to output every field used in the filtering logic should work but I'm having a hard time finding such a pattern or examples online or even in the DAX book. It seems to be the || across more than 1 column part in particular that is causing trouble. = CALCULATETABLE ( SUMMARIZECOLUMNS ( 'DimTable1'[Field_A], 'DimTable1'[Field_G], "Total Amount", [Total Amount] ), 'DimTable4'[Field K] = "Revenue", 'DimTable1'[Field_A] IN { "West", "East" } || ( 'DimTable1'[Field_G] IN { "Red", "Blue" } && 'DimTable1'[Field_A] = "" ) )Solved7.3KViews0likes6Comments