Forum Discussion
Dax
CALCULATED COLUMN:
IF(MAX('Family'[Product Family]="XXX" || MIN(‘Prod'[Team-Prod]=”YYY”
AVERAGEX(
FILTER(
Tablename,
AND(Tablename [assignment id],
AND(Tablename [Status ]=CLOSED,
AND(Tablename [Type ]=”A”,
AND(Tablename [Effort time]<>0,
Tablename [ Time]<>BLANK()
)
)
)
)
),
Tablename [Effort Time]
),
AVERAGEX(
FILTER(
Tablename,
AND(Tablename [Primary Team id],
AND(Tablename [Status]="Closed",
AND(Tablename [Product Family]<>”XXX”,
AND(Tablename [Product Family ]<>”YYY”,
AND(Tablename [effort time]<>0,
Tablename [Effort time]<>BLANK()
)
)
)
) ) ),
Tablename [ Effort time] ))
This code is my calculated column..I am trying to do in measure . But I got error as (Two few arguments were passsed to the IF condition.the minimum argument count for function is 2...)
Can anyone please help with this solution.
AtchayaP , In above code Min and Max were not closing
IF( MAX('Family'[Product Family])="XXX" || MIN('Prod'[Team-Prod])="YYY"
AVERAGEX(
FILTER(
Tablename,
AND(Tablename [assignment id],
AND(Tablename [Status ]=CLOSED,
AND(Tablename [Type ]=”A”,
AND(Tablename [Effort time]<>0,
Tablename [ Time]<>BLANK()
)
)
)
)
),
Tablename [Effort Time]
),
AVERAGEX(
FILTER(
Tablename,
AND(Tablename [Primary Team id],
AND(Tablename [Status]="Closed",
AND(Tablename [Product Family]<>”XXX”,
AND(Tablename [Product Family ]<>”YYY”,
AND(Tablename [effort time]<>0,
Tablename [Effort time]<>BLANK()
)
)
)
) ) ),
Tablename [ Effort time] ))
2 Replies
- amitchandakSuper User
AtchayaP , In above code Min and Max were not closing
IF( MAX('Family'[Product Family])="XXX" || MIN('Prod'[Team-Prod])="YYY"
AVERAGEX(
FILTER(
Tablename,
AND(Tablename [assignment id],
AND(Tablename [Status ]=CLOSED,
AND(Tablename [Type ]=”A”,
AND(Tablename [Effort time]<>0,
Tablename [ Time]<>BLANK()
)
)
)
)
),
Tablename [Effort Time]
),
AVERAGEX(
FILTER(
Tablename,
AND(Tablename [Primary Team id],
AND(Tablename [Status]="Closed",
AND(Tablename [Product Family]<>”XXX”,
AND(Tablename [Product Family ]<>”YYY”,
AND(Tablename [effort time]<>0,
Tablename [Effort time]<>BLANK()
)
)
)
) ) ),
Tablename [ Effort time] )) - AtchayaPHelper V
thank you so much