Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Condiciones en medida

Hola comunidad. Necesito clasificar a los clientes por condiciones. Tengo una base de datos con una conexión de consulta directa y condiciones en dos tablas que se cargan localmente (desde ShareP...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Pruebe las dos medidas siguientes:

Classification type 1 = 
VAR measurecalc = [Value by Customer]
VAR temptable =
    CALCULATETABLE (
        'LD - First Conditions',
        'LD - First Conditions'[Customer] IN VALUES ( 'DQ - Sample Table'[Customers] ),
        'LD - First Conditions'[Channel] IN VALUES ( 'DQ - Sample Table'[Channel] ),
        'LD - First Conditions'[Target Value] <= measurecalc
    )
RETURN
    MAXX ( temptable, 'LD - First Conditions'[Type] )

Classification type 2 = 
VAR measurecalc = [Value by Customer]
VAR temptable =
    CALCULATETABLE (
        'LD - Second Conditions',
         'LD - Second Conditions'[Customer] IN VALUES ( 'DQ - Sample Table'[Customers] ),
        'LD - Second Conditions'[Period] IN VALUES ( 'LD - Second Conditions'[Period] ),
        'LD - Second Conditions'[Target Value] <= measurecalc
    )
RETURN
    MAXX ( temptable, 'LD - Second Conditions'[Type] )