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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AnSchmi
Helper II
Helper II

Filtering Customer Sales Value and Vendor Receipt Value from single transaction file

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: 

Total Sales Value = CALCULATE(SUM('f Transactions'[Value]), 'f Transactions'[Type.Transaction] = "BD" )
Total Receipt Value = CALCULATE(SUM('f Transactions'[Value]), 'f Transactions'[Type.Transaction] = "RP" )
In my Report I would like to filter records in 3 different Matrix.
Item Sales Matrix > Customer Sales Matrix + Vendor Receipts no problem. 
Customer Sales Matrix > Filtering Vendor Receipts Matrix not working. 
The challenge is to Filter a Customer in the Customer Sales Matrix and to get for all selected items the Vendor Receipts Matrix filtered? 
AnSchmi_0-1659959113578.png

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



1 ACCEPTED SOLUTION
changqing
Resolver II
Resolver II

Hi @AnSchmi ,

 

Customer sales fileds:

changqing_1-1660210258189.png

Vendor receipts fileds:

changqing_3-1660210385947.png

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.

changqing_0-1660210209882.png

changqing_4-1660210671639.png

PBIX file

 

Best Regards,
changqing

View solution in original post

2 REPLIES 2
changqing
Resolver II
Resolver II

Hi @AnSchmi ,

 

Customer sales fileds:

changqing_1-1660210258189.png

Vendor receipts fileds:

changqing_3-1660210385947.png

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.

changqing_0-1660210209882.png

changqing_4-1660210671639.png

PBIX file

 

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. 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors