Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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