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_Admin4 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] ), "" )