Forum Discussion
Optimizing Measures to avoid Out of memory errors
I need help in understanding how to optimize some measures and have a few questions. My system configuration is : OS : Windows 10 (64 bit) Memory : 8 GB RAM MSOffice : Office 2016 Pro (64 bit)...
OK, so I guess something like this should work, as long as you add the additional criteria you want to ignore to the
_CharsAll
UniquesCount:=
VAR _Chars =
VALUES ( fData[Char Value] )
VAR _CharsAll =
CALCULATETABLE ( fData, _Chars, ALL ( dDate[Year] ), ALL(dCountry[Country]) ) --add other filters here
VAR _CharsSummary =
GROUPBY (
_CharsAll,
fData[Char Value],
"MaxYear", MAXX ( CURRENTGROUP (), RELATED ( dDate[Year] ) ),
"MinYear", MINX ( CURRENTGROUP (), RELATED ( dDate[Year] ) ),
"NrOfChars", COUNTAX(CURRENTGROUP(), fData[Char Value])
)
VAR _SameYearChars =
FILTER ( _CharsSummary, [MaxYear] = [MinYear] )
RETURN
SUMX(_SameYearChars,[NrOfChars])
Hi Stachu,
I am getting the following memory error everytime (tried restarting excel also) when applying the measure on my original dataset, though i am using Excel 2016 Pro 64 bit, with 8 GB RAM on a Windows 10 64 bit machine.
UniquesCount:= // get unique Char values VAR _Chars = VALUES ( fData[Char Value] ) // Filter fData table based on only the unique Char values VAR _CharsAll = CALCULATETABLE ( fData, _Chars, ALL ( dDate[Year] ), ALL ( dDate[Date] ), ALL ( dCountry[Country] ), ALL ( dCategory[Category] ), ALL ( dBrandOwner[BrandOwner] ), ALL ( dBrand[Brand] ), ALL ( dSubBrand[SubBrand] ), ALL ( dInnType[InnType] ), ALL ( dInnSubType[InnSubType] ), ALL ( dCharDescription[CharDescription] ) ) // VAR _CharsSummary = GROUPBY ( _CharsAll, fData[Char Value], "MaxYear", MAXX ( CURRENTGROUP (), RELATED ( dDate[Year] ) ), "MinYear", MINX ( CURRENTGROUP (), RELATED ( dDate[Year] ) ), "NrOfChars", COUNTAX( CURRENTGROUP (), fData[Char Value] ) ) // VAR _SameYearChars = FILTER ( _CharsSummary, [MaxYear] = [MinYear] ) RETURN SUMX( _SameYearChars, [NrOfChars] )
I have added the additional filters. Can this measure be optimized?