Calculator to aligment sales reps to a region

[Konrad_Schargel]

Hi everyone, 

Is the first time that I write a post here so I don't know if I am doing by the right way. 

I would need you're help to know if is this request is possible or not. 

I want to develop a dashboard to the commercial director. I have 2 tables, one with a column with the regions (Zone 1, Zone 2, etc.. ) and other column with the default sales reps assigned and a second table with the name of the reps. 

The commercial director wants to change the territory to a other new sales reps and he wants to do it in the dashboard with a slicer or something like that. 

Is possible assign a new territory to a new user directly in the dashboard with some Dax measure? 

I want to considerer this option first before use an external excel. 

Could you help me please? 

Thank you

[v-jianboli-msft · Accepted solution]

Hi @Konrad_Schargel ,

You can't change your original data by changing the report, but if you just want to modify the report, you can try this:

Based on your description, I have created a simple sample:

First, create a new table for slicer:

Table 2 = CROSSJOIN(VALUES('Table'[Regions]),VALUES('Table (2)'[the name of the reps]))

Then use the new table to create a slicer:

Applt the measure to the table visual:

Measure = 
IF (
    ISFILTERED ( 'Table 2' )
        && MAX ( 'Table'[Regions] ) IN SELECTCOLUMNS ( 'Table 2', "Regions", [Regions] ),
    MAXX (
        FILTER ( 'Table 2', [Regions] = MAX ( 'Table'[Regions] ) ),
        [the name of the reps]
    ),
    MAX ( 'Table'[the default sales reps assigned] )
)

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Konrad_Schargel]

It works perfectly!  

Thank you very much for your help. 

Best regards,
Konrad