Forum Discussion

AnSchmi's avatar
AnSchmi
Icon for Helper II rankHelper II
4 years ago
Solved

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...
  • changqing's avatar
    4 years ago

    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.

    PBIX file

     

    Best Regards,
    changqing