Forum Discussion

lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

Calculation

Goodmorning Community, i need your precious help. I uploaded my dataset in xlsx. Is not the complete dataset but is only the rows with FLG_KRI_08 = 1 e FLG_CONSOCIATA = 1 so we have to consider...
Need Help
  • lucadelicio's avatar
    lucadelicio
    1 year ago

    Thank you for your answer.
    The logic it's clear but the formula was difficult to find.
    With the help of artificial intelligence i was arrived to the solution with the 

    IN
            SELECTCOLUMNS()
    option thank you everybody for your help!

    COUNTROWS(
        FILTER(
            D_STORICO_VARIANTI,
            D_STORICO_VARIANTI[FLG_KRI_08] = 1
            && D_STORICO_VARIANTI[FLG_CONSOCIATA] = 1
            && D_STORICO_VARIANTI[DAT_LANCIO_RILASCIO] <= MAX('DIM Data Storico Varianti'[Data])
            && D_STORICO_VARIANTI[SKY_KRI_CONTRATTO_PASSIVO] IN
            SELECTCOLUMNS(
                FILTER(
                    D_STORICO_VARIANTI,
                    D_STORICO_VARIANTI[DAT_LANCIO_RILASCIO] >= MIN('DIM Data Storico Varianti'[Data])
                    && D_STORICO_VARIANTI[DAT_LANCIO_RILASCIO] <= MAX('DIM Data Storico Varianti'[Data])
                    && D_STORICO_VARIANTI[FLG_KRI_08] = 1
                    && D_STORICO_VARIANTI[FLG_CONSOCIATA] = 1
                ),
                "SKY_KRI_CONTRATTO_PASSIVO", D_STORICO_VARIANTI[SKY_KRI_CONTRATTO_PASSIVO]
            )
        )
    )
lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
1 year ago

Someone can help me?
I can give you more information if you need.
Thank you