Error with AverageX

nehajadhav166 

Please try

Cpk =
VAR selected_Value =
    SELECTEDVALUE ( TestData[Name] )
VAR selected_Char =
    SELECTEDVALUE ( TestData[Characteristic.Name] )
VAR selected_maxdate =
    IF ( ISFILTERED ( 'TestData'[Date] ), MAX ( 'TestData'[Date] ) )
VAR selected_mindate =
    IF ( ISFILTERED ( 'TestData'[Date] ), MIN ( 'TestData'[Date] ) )
VAR _tab =
    VALUES ( TestData[Date] )
VAR selected_Machine =
    SELECTEDVALUE ( TestData[Source.Name.1] )
VAR selected_adpater =
    SELECTEDVALUE ( TestData[TestHeader.testAdapter.serialNo] )
RETURN
    SWITCH (
        TRUE (),
        SEARCH ( "loopback", selected_Value,, 0 ) <> 0,
            AVERAGEX (
                FILTER (
                    RFLoopback,
                    RFLoopback[Cpk] <> BLANK ()
                        && RFLoopback[Characteristic.Name] = selected_Char
                        && RFLoopback[Source.Name.1] = selected_Machine
                        && RFLoopback[TestHeader.testAdapter.serialNo] = selected_adpater
                        && DATESBETWEEN ( RFLoopback[Date], selected_mindate, selected_maxdate )
                ),
                RFLoopback[Cpk]
            ),
        ""
    )

tamerj1 , I tried but still same error.

Thanks,

Neha

tamerj1 , Error seems to be gone but I dont get correct calculeted value for Cpk.

Looks like caldender function not considering date range. If I user calender function seperatly as measure I get similar error as above.

Do I have to conver any column/value?

Thanks,

Neha

tamerj1  yes in original measure I used same and then I am getting error.Is there any other way yo handle this?

Thanks,

Neha