Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
AnSchmi
Helper II
Helper II

Filtering Vendor Receipts from Selected Customer Sales

Hi, it's me again,
I'm still trying to filter receipt values based on selected customer sales. 
My model has 2 fact tables (billing transactions + receipt transactions). 

AnSchmi_0-1660641476118.png

I would like to select in my table the customer in order to get all sales customers and based on the selected items the 
vendors who has delivered the items. 
Report with tables no selection

AnSchmi_1-1660641722408.png

Customer Name 1 selected 

AnSchmi_2-1660642091960.png

Has someone an idea how I can filter the selected value in the Vendor Receipts table ? 
My model I attached to this post. 
Thanks a lot for your help and patients. 
https://fileshare.ssl.iscar.com/data/public/79bbab - Click Here!

2 REPLIES 2
NickolajJessen
Solution Sage
Solution Sage

It's a bit odd to have customers and vendors in the same DIM table. Is there a special reason for this?

In can be solved in a few different ways. 
The solution here creates a list of the product in the current selection and filters your Total sales Value based on the selection:

https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg

Dear NickolajJessen, 
thanks a lot for your reply, I'm very much appreciating your feedback.
I have pulled the data from DB2 where customers and vendors are stored in one file. Further transactions are organized in one file as well (Orders, Billing, Receipts, etc.) 
I understand now that it is a mistake not to seperate the records. I will change the model accordingly. 

I have a last question regarding your solution creating a list. 

When I adopt this solution to a model with several hundred thousand of records, do I get a performance problem ? 

If yes, is there an alternative solution summarizing the selected billing items to a variable to be filtered afterwards to get the receipt value ? better performance ? 
Thanks a lot for your help in advance. 

  

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.