A query may contain up to a total of 100 extension measures and Columns

[Anonymous]

Today, When I create a measures  using switch to consolidate many measures in one, I got below error message, Could you please help to advise how to fix this issue, thanks in advance.

The query contains too many extension measures or columns, A query may contain up to a total of 100 extension measures and Columns, please reduce the number of extension measures or columns in this query.

[manvishah17]

Hi everyone,

I’m trying to understand the actual evaluation behavior behind this error:
“A query may contain up to a total of 100 extension measures and columns.”

When we use a large SWITCH or nested IF measure that references many other measures, is the DAX engine expanding/evaluating all referenced measures upfront while building the query plan, which causes the extension limit to be exceeded?

Or does the engine only evaluate the specific measure branch whose condition matches (row-by-row or cell-by-cell), similar to short-circuit logic?

In other words, is this limit being hit because:

• all measure branches are included during query compilation/optimization, even if logically only one branch should execute,
  or

• the matching condition still causes other branches to be evaluated at runtime?

Any clarification on how DAX handles measure expansion vs conditional execution would be very helpful.

[v-xuding-msft]

Hi @Anonymous ,

It may be caused that there are too many measures consolidated  in the new one. If the measures are not used separately, you could use variables to define them into one measure.

VAR 

variables-in-dax 

And based on the error message, I think you might do a lot of model calculations in your report. You could reference the documents to optimize it.

Data reduction techniques for Import modeling 

Use Performance Analyzer to examine report element performance 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Actually I am using all the consolidate measures separately, I use a switch function to consolidate them, May I know this error  based off single Measure or the Whole visual's query?

Why the same visual can be used in a simple visual but not in a complex visual? Thanks.