Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |