Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

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

  • 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] ))