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.