Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Memory Issue with Avg Last 3 months Measure in Detailed Matrix Report

Hi PBI Expert,    I've been trying on this calculation and it works when minumum amount of materials is filtered but will get into memory issue when i unfilter the material (can be up to 100++). Ho...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

Try like this:

Avglast3mthRev =
VAR CurrentMonthOrder =
    MAX ( Data[Period Number] )
RETURN
    CALCULATE (
        DIVIDE ( [Rev], 3 ),
        FILTER (
            ALLSELECTED ( Data ),
            Data[Period Number] <= CurrentMonthOrder
                && Data[Period Number] >= CurrentMonthOrder - 2
        )
    )

If it doesn't solve your problem, Please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.