cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jprdynamicapps
Helper III
Helper III

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

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User III
Super User III

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User III
Super User III

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors