Filter replacement inside matrix with visual filter

[jprdynamicapps]

I have a matrix displaying a sum of sales quantity and I have a slicer picking date periods. 

I am displaying the sum of sales qty.  I am also displaying the sum of sales for all dates (using ALL()) and that is working fine.

I am also attempting to show the sales quantity for date period 1 inside the matrix as a baseline and that is not working.  I expected my stated filter context to replace the existing filter context, but it seems to be getting intersected.  If date period 1 is in the slicer selection, it displays correctly, but if date period 1 is not, it is blank. 

I hope I'm just doing something silly here, but if this can't work for some reason, I would have to remove the visual filter and then "manually" apply the slicer to the salesqty.  I tried that in the second matrix but couldn't get that working either.

Appreciate any assistance.  PBIX at https://www.dropbox.com/s/vgpvkq36k3uo9lg/baseline%20inside%20matrix%20with%20slicer.pbix?dl=0.

Thanks.

-jpr

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.  In both tables, you had dragged the fields from the wrong tables.  Also, i have corrected your measure.

Hope this helps.

[jprdynamicapps]

Thanks, Ashish.  As you noticed, I did something wrong that which looked right to my inexperienced eye.

Adding a filter in calculate is done as in line 1 below, not as in line 2 below.

Thank you.

SalesInPeriod1 = calculate(sum([SalesQty]),'dim DatePeriod'[DatePeriod]=1)

SalesInPeriod1 = calculate(sum([SalesQty]),FILTER('dim DatePeriod',[DatePeriod]=1))

[Ashish_Mathur]

You are welcome.