Sales provision report

MedtechServices - I would start by unpivoting your Goods group columns in Table 1.

MedtechServices, try this:

1. Unpivot the table Reporting of Sales person (table 1). The data should look like this:

2. Create calculated columns:

Reporting of Sales person table (table 1):
Key = SalesReporting[Customer] & "-" & SalesReporting[Goods Group]

Provision table (table 3):
Key = Provision[Customer] & "-" & Provision[Goods Group]

Sales Person Visited = 
VAR vKey = Provision[Key]
VAR vSalesTable =
    FILTER ( SalesReporting, SalesReporting[Key] = vKey )
VAR vRowCnt =
    COUNTROWS ( vSalesTable )
RETURN
    IF ( vRowCnt > 0, "Y", "N" )

3. Join tables:

4. Create slicer using Provision[Customer].

5. Create table visual.

6. Set table visual filter:

7. Result:

MedtechServices , Unpivot the table and merge them with customer id join and try

https://radacad.com/pivot-and-unpivot-with-power-bi

Unpivot - https://www.youtube.com/watch?v=2HjkBtxSM0g
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Append - https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Hi MedtechServices,

Did these suggestions help with your scenario? IF this is a case, you can consider accepting the most suitable one as solution to help others who have similar requirements.

If not, please share more detailed information to help us clarify your requirement.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng