Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conversión de SQL a DAX

Quiero convertir la siguiente consulta en una medidaDAX -

seleccionar recuento(1) de [PRNTO]. [vw_DIM_PRNTO_Outlet] un

donde a.ctry_id 173

y rss_in 1 y hpc_busn_in 'HPC' y b2b_strt_dt<'2020-02-01'

y outlet_id en

(seleccione outlet_id de [SDDW]. [FCT_DSTR_SEC_SLS_DATA]

donde ( [Blg_Type_Cd] en ('ZRSS','ZRS1') o [Sls_Sts_Cd] 'B2B')

y ctry_id 173

y ertm_type_cd 'B2B'

y busn_catg_cd 'HPC'

y cal_dt entre '2020-02-01' y '2020-07-31'

)

Nota-

vw_DIM_PRNTO_Outlet y FCT_DSTR_SEC_SLS_DATA tienen una relación de 1 M en el modelo de datos.@dax

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hola @mehra_kanishk88 ,

    Algo así.

    Measure =
CALCULATE (
    COUNT ( 'Table 1'[Column1] ),
    FILTER (
        'Table 1',
        conditions
        &&
        'Table 1'[Column2]
            IN CALCULATETABLE (
                VALUES ( 'Table 2'[Column1] ),
                FILTER ( 'Table 2', conditions )
            )
    )
)

    Saludos

    Jay

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    @mehra_kanishk88 ,

    una medida como

    medida :
    Var _out - summarize(filter( (FCT_DSTR_SEC_SLS_DATA, [Blg_Type_Cd] en "ZRSS","ZRS1" [Sls_Sts_Cd] "B2B") && [ctry_id]-173 && [ertm_type_cd]-"B2B"
    && [busn_catg_cd]-"HPC" && [cal_dt] >- date(2020,1,1) & [cal_dt] >- date(2020,7,31) ),[outlet_id])
    devolución
    calculate(count([outlet_id]) , filter(FCT_DSTR_SEC_SLS_DATA, [rss_in]-1 && [hpc_busn_in]-"HPC" && [b2b_strt_dt]<date(2020,02,01) && outlet_id en _out))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hola @mehra_kanishk88 ,

    Algo así.

    Measure =
CALCULATE (
    COUNT ( 'Table 1'[Column1] ),
    FILTER (
        'Table 1',
        conditions
        &&
        'Table 1'[Column2]
            IN CALCULATETABLE (
                VALUES ( 'Table 2'[Column1] ),
                FILTER ( 'Table 2', conditions )
            )
    )
)

    Saludos

    Jay