I am wondering if anyone can help.
I created a measure that calculates the (previous month and by quarter )using DAX formula calculate with a filter.
Even though the formula works there is no way to apply additional filters to the measure with a slicer.
Below is the function I am using if needed, is there any workaround to this?
@adetogni its a simple sum
it works only when i filter by month but when filtering by location it doesn't, here is a screen shot of the relations if this will help.
any way thank you for your response