Forum Discussion

nehajadhav166's avatar
nehajadhav166
Resolver I
4 years ago
Solved

Error with AverageX

Hi Experts,   I have created measure : Cpk = Var selected_Value=SELECTEDVALUE(TestData[Name]) Var selected_Char=SELECTEDVALUE(TestData[Characteristic.Name]) Var selected_maxdate=IF (ISFILTE...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi nehajadhav166 
    Calendar funtion works normally inside measures. You can also replace it with DATESBETWEEN and see if the result changes.

  • tamerj1's avatar
    tamerj1
    4 years ago

    nehajadhav166 
    I mean 

    && RFLoopback[Date] IN DATESBETWEEN ( RFLoopback[Date], selected_mindate, selected_maxdate )
  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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 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
                        && RFLoopback[Date] IN CALENDAR ( selected_mindate, selected_maxdate )
                ),
                RFLoopback[Cpk]
            ),
        ""
    )