Sumarrize rows

[Easley08]

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 · Accepted solution]

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 )