Create mapping column based on multiple columns

[Anonymous]

Hello,

I am new to power bi.

And im kind of stuck with one scenario.

Please consider following table as my Input table:

ID	Responsible Person	Domain	Org Unit
1	ABC	A
2	XYZ		UN1
3	PQR
4	XYZ
5	ABC		UN1
6	MNO	A
7	MNO
8	EFG
9	EFG	A
10	ABC

Now i need to visualize it as how many applications are there by per region. But region is not included in input table.

So i created a new mapping table. Region is derived by Respnsible person. Each distinct Responsible person is assigned for per region. Which i was able to achieve. But there was new regions addded which were not dependant on Responsible person but are responsible on column Domain and Org Unit.

So now what i want is where Domain is "A" is assigned to Region "Reg1".

Also where Org Unit is "UN1" is assigned to "Reg2".

And previous condition for deriving regions remains same(with responsible person).

I tried to achieve it by Conditional Column but it doesnt work properly.

The count doesnt match.

Can anyone please suggest me how do i approach this scenario.

Thanks in Advance..!!!

[Anonymous · Accepted solution]

Hi @Anonymous 

Try to build a calculated column by switch function.

Region =
SWITCH (
    TRUE (),
    'Table'[Domain] = "A", "Reg1",
    'Table'[Org Unit] = "UN1", "Reg2",
    'Table'[Responsible Person]
)

Result is as below.

Best Regards,
Rico Zhou

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