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.
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).
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
Customer Name 1 selected
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!
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.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |