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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.