Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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.
User | Count |
---|---|
83 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
42 | |
41 | |
33 | |
32 | |
31 |