Debt overdue days in power Bi

[Analitika]

Hi,

I have situation when i need calculate debt in delayed days in ranges like 1-30 days, 31-60 days and more. my measure:

Filtered measure_t5 = 
SUMX (
    FILTER (
        VALUES ( I44_SKOL[I44_DOK_NR] ),
        [20_2_1_DATA PRADELSIMAS] > 360
    ),
    CALCULATE ( [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] )
)

data_pradelsimas is days overdue

bendra_skola is debt.

So how fix my measure?

[v-jingzhang]

Hi @Analitika 

Assume that [20_2_1_DATA PRADELSIMAS] and [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] are both measures, you can try below measure

Filtered measure_t5 =
VAR _table =
    SUMMARIZE (
        I44_SKOL[I44_DOK_NR],
        "data_pradelsimas", [20_2_1_DATA PRADELSIMAS]
    )
RETURN
    SUMX (
        FILTER ( _table, [data_pradelsimas] > 360 ),
        [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)]
    )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.