Forum Discussion

Easley08's avatar
Easley08
Icon for Helper I rankHelper I
2 years 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  ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years 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 )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years 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 )