Create Measure based on text columns in table and parameters

[Anonymous]

I want to create a measure based on parameters. i have a table which contains site type, so based on site type i have to create a parameter. the parameter is then used to create a measure.

eg :

table 1 :

Ticket#,assignment_group,site_type

table 2 :

engineer name,fte count,assignment group

parameter 1 :

value = 7

parameter 2 :

value = 10

i need to create a measure where

if site_type = x then parameter1*fte count

if site_type = y then parameter2*fte count

i will use the above measure to show in graph,matrix visualization by group name

eg

Assignment_Group	Tickets#	FTE	Measure I want to create	Avg Tickets Per Day
A	997	2.2	22	12.4625
B	973	2.2	22	11.44705882
C	948	3	30	11.42168675
D	881	2	20	11.0125
E	739	2	20	9.2375
F	328	1	10	4.61971831

[Anonymous]

brilliant and thanks

[amitchandak · Accepted solution]

@Anonymous , Assume these two what if parameter with measures p1 and p2 and fte count is a measure too

Sumx(values(Table[Assignment_Group]) , if(Table[Site Type]= "X", [P1]*[fte count], [fte count]*[P2]) )