Forum Discussion
Filter replacement inside matrix with visual filter
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
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.
3 Replies
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.
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))You are welcome.
