Calculate() filter doesn't return expected value

[Anonymous]

Hi,

I've been having issues with a measure that doesn't return the value you'd expect. I did find a topic where the user had the same issue, but the answer didn't quite explain why they should use ALL(), and in my case I do need filters to apply when calculating the measure : 

Monthly period	Quantity	Type
202108	1	Online
202108	2	Wholesale
202109	5	Wholesale
202109	1	Wholesale

Latest Quantity:=
VAR Max_Date =
    MAX ( 'Sales'[MONTHLY_PERIOD] )
RETURN
 CALCULATE (
                        SUM ( 'Sales'[Quantity] ),
                        Sales[MONTHLY_PERIOD] = Max_Date
                    )

This returns the entire sum of 9 whereas what I want it to return is 6, the sum for the latest period only.

I also want it to take into account the filters that are apply, so it should return 1 if I apply a 'Type = Online' filter.

Is there any way to resolve this ?

Thanks in advance.

[v-jingzhang]

Hi @Anonymous 

I put your measure in a card visual and use a slicer to filter Type column. The result is correct as expected. See the attached pbix. Which visual do you put this measure in? If you put other columns into the same visual, they may provide some filters to the measure result. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous , Try like

Latest Quantity:=
VAR Max_Date =
MAXX (allselected('Sales'), 'Sales'[MONTHLY_PERIOD] )
RETURN
CALCULATE (
SUM ( 'Sales'[Quantity] ),
filter(sales, Sales[MONTHLY_PERIOD] = Max_Date)
)

[Anonymous]

Hi @amitchandak ,

Thanks for your answer, althouh I tried this solution and it still returns the total sum of the sales.