Countrows incorrecto

Hola Comunidad, Tengo una medida para calcular el total de licencias tomadas que excluye los fines de semana y días festivos. Countrows no es un resultado correcto. Por ejemplo, en diciembre, em...

Syndicate_Admin

4 years ago

@ExcelPBI , Prueba como

Total Leaves = 
CALCULATE( SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'Emp Leave', 'Emp Leave'[emp_code], 'Emp Leave'[date_start], 'Emp Leave'[date_end] ),
        "diff",
            COUNTROWS (
                FILTER (
                    Datedim,
                    Datedim[Date] >=  ( 'Emp Leave'[date_start] )
                        && Datedim[Date] <=  ( 'Emp Leave'[date_end] ) && datedim[working days]=1
                )
            )
    ),
    [diff]
), CROSSFILTER('Emp Leave'[date_start],datedim[Date],None))

Total Leaves = CALCULATE( SUMX ( ADDCOLUMNS ( SUMMARIZE ( 'Emp Leave', 'Emp Leave'[emp_code], 'Emp Leave'[date_start], 'Emp Leave'[date_end] ), "diff", COUNTROWS ( FILTER ( Datedim, Datedim[Date] >= ( 'Emp Leave'[date_start] ) && Datedim[Date] <= ( 'Emp Leave'[date_end] ) && datedim[working days]=1 ) ) ), [diff] ), CROSSFILTER('Emp Leave'[date_start],datedim[Date],None))

Forum Discussion

Countrows incorrecto