Optimizing DAX measures to avoid "Exceeded available Resources" error in Power BI Services

Hi All,

I am new to Power BI.
For one of my visuals, In Power BI desktop, I am getting an error as “There's Not Enough Memory To Complete This Operation” and
In Power BI Services, I am getting an error as "visual has exceeded the available resources".

I have 8 GB of RAM and the query that’s running this visual has around 9 million records and I am using couple of DAX Measures in this visual.

I did some research and I have found out that “Power BI services has a limit of 1 GB for any queries that it tries to run” and optimizing my measures might help to resolve the issue.
I have used 3 measures in my visual “fAvgPerMonth”, “fAvgForLast6Month” and “fPercentageChange”.

Could these measures be tuned ?

#Measure 1 
fAvgPerMonth = CALCULATE( AVERAGEX (‘Table’, [fValues] ),
			 DATESINPERIOD(‘Table’ [Period],MAX(‘Table’ [Period]),-30,DAY))

#Measure 2
fAvgForLast6Month = CALCULATE( AVERAGEX (‘Table’, [fValues] ),
			 DATESINPERIOD(‘Table’ [Period],MAX(‘Table’ [Period]),-6,MONTH))

# fValues is another measure used within the above 2 main measures
fValues = IF(HASONEVALUE(ParamMetric[Metric])  && ISFILTERED(ParamMetric[Metric]), 
               SWITCH (VALUES(ParamMetric[Metric]),
                    {"Net Sales"}, SUM(‘Table’[Net Sales]),
                    {"Redemptions"}, SUM(' Table’[Redemptions]),
                    {"Gross Sales"},SUM('Table’ [Gross Sales]),
                    {"Assets”}, SUM('Table’ [Gross Sales]),blank()))

#ParamMetric is a calculated table 
ParamMetric = {("Assets"),("Gross Sales"),("Net Sales"),("Redemptions")}
"Net Sales", "Redemptions", "Gross Sales" and "Assets” are 4 different columns in the table which are used as slicer with the help of the above calculated table to filter fValues.

#Measure 3 
fPercentageChange = 
            IF(    ([Percentage] >= min(ParamPercentage[PercentChange]))
                        &&
                   ([Percentage] <= max(ParamPercentage[PercentChange])) , 
                   [Percentage],blank())

#where:
Percentage = Divide( ([AvgPerMonth] - [AvgForLast6Month]), [AvgForLast6Month] )

#And ParamPercentage is a calculated table 
ParamPercentage = GENERATESERIES(-4,4,0.01)

#ParamPercentage[PercentChange] is used as a slicer ( Percentage range) to filter the fPercentageChange Values.

Where should I begin and How to resolve this issue?
Any feedback is appreciated.