Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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]) )
brilliant and thanks
@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]) )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |