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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.