Error: A query may contain up to a total of 100 extension measures and columns
Hi everybody, today I encountered the following error while trying to perform a sum over different measures: "The query contains too many (127) 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." This happens when I try to sum 8 measures to obtain one (simply tot = m1 + m2 + ... + m8). Each of the measure is calculated based on other measures and aggregations, but some of these correlated measure are not visible to me (as per client disposal I can work only on the front end of the PowerBi Dashboard and I can not create columns, only measures) so I can not try to optimize the data model . The question is, is there a way to perform the summation? Any suggestion will be usefull. Thank you in advance, Silvano