The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear All,
I have a simple model. transaction file has relationship to Calendar Table, Item masterfile and customer masterfile table.
The transaction file contains several type of transactions. In my example Customer Billing and Vendor Receipt Transactions.
I'm calculating the Sales and Receipt value with following measures:
The pbix file can be downloaded under following link:
https://fileshare.ssl.iscar.com/data/public/f25a1a
Thanks a lot for your help in advance
Solved! Go to Solution.
Hi @AnSchmi ,
Customer sales fileds:
Vendor receipts fileds:
Both matrices contain the same fields, but as it happens, the matrix automatically hides items with no data, so cross-filtering does not seem to be possible. Try checking the "Show items with no data" name field.
Best Regards,
changqing
Hi @AnSchmi ,
Customer sales fileds:
Vendor receipts fileds:
Both matrices contain the same fields, but as it happens, the matrix automatically hides items with no data, so cross-filtering does not seem to be possible. Try checking the "Show items with no data" name field.
Best Regards,
changqing
Dear changqing,
thanks for your answer. But this solution does not work.
I'm looking for an solution to filter the selected customer items and then based on the filter of items to show all receipts + vendors.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
81 | |
75 | |
52 | |
48 |
User | Count |
---|---|
133 | |
124 | |
78 | |
64 | |
61 |