Using NONVISUAL has bugs when used in SUMMARIZECOLUMNS when the semantic model has Coalesced setting for Value Filter Behavior. The result of the query changes depending on the expansion of the levels in the matrix visual that generates the DAX query.
Example of the inconsistent behavior: NONVISUAL in Coalesced Mode on DAX.do
Workarounds:
-
Use the Independent setting for Value Filter Behavior. This is the recommended solution.
-
Avoid using the filter arguments in SUMMARIZECOLUMNS and move filters in an outer CALCULATETABLE function (not possible for DAX queries generated by Power BI).