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.

[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.