Forum Discussion

Easley08's avatar
Easley08
Helper I
1 year ago
Solved

Sumarrize rows

Hi, 

is there a way to put this on measure currently my issue is getting the retention of customer

logic is = COUNT the dealer with maturing = cash then for the past 3 months with purchase order 

 

current measure : 

=SUMMARIZE(FACT_ONEPC,FACT_ONEPC[DLR_LINK],"Maturing",CALCULATE([Maturing Amt],FACT_ONEPC[TRANS_TYPE] = "CASH" && DATEADD(FACT_ONEPC[INV_DT],-3,MONTH )))

 

 

thanks.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    I am not sure if I understood your question correctly, but please try something like below.

     

    current measure : =
VAR _t =
    SUMMARIZE (
        FACT_ONEPC,
        FACT_ONEPC[DLR_LINK],
        "Maturing",
            CALCULATE (
                [Maturing Amt],
                FACT_ONEPC[TRANS_TYPE] = "CASH"
                    && DATEADD ( FACT_ONEPC[INV_DT], -3, MONTH )
            )
    )
RETURN
    COUNTROWS ( _t )

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

    Hi,

    I am not sure if I understood your question correctly, but please try something like below.

     

    current measure : =
VAR _t =
    SUMMARIZE (
        FACT_ONEPC,
        FACT_ONEPC[DLR_LINK],
        "Maturing",
            CALCULATE (
                [Maturing Amt],
                FACT_ONEPC[TRANS_TYPE] = "CASH"
                    && DATEADD ( FACT_ONEPC[INV_DT], -3, MONTH )
            )
    )
RETURN
    COUNTROWS ( _t )