Forum Discussion
Syndicate_Admin
4 years agoAdministrator
Error con AverageX
Hi Expertos, He creado medida : Cpk = Dónde selected_Value=SELECTEDVALUE(TestData[Nombre]) Dónde selected_Char=SELECTEDVALUE(TestData[Characteristic.Name]) Dónde selected_maxdate=Si (ISFI...
Syndicate_Admin
4 years agoAdministrator
Syndicate_Admin
4 years agoAdministrator
Por favor, pruebe
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]
),
""
)