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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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