Report to check if vendor is setup up correctly

[vxmine]

Hello,

I'm trying to write a report that will tell us if vendors are set up in the proper companies. I'm playing with a matrix, but the matrix will not show the column if there is no data to support it. Here are the 3 tables I'm working with and an example:

Company table: main financial table listing all available companies

vendor table 1: vendor table with no company name (vendor master)

vendor table 2: each row has the vendor name and the company they are set up for. In this example, there would be two rows in that table (financial system company vendor master)

Any help or guidance is greatly appreciated. 

Vendor	Company A	Company B	Company C
Acme	Yes	No	Yes

[mwegener · Accepted solution]

Hi @vxmine 

You may download my PBIX file from here.
Hope this helps.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[vxmine]

That worked great, Marcus! Thanks!