Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure DAX

  Charity (Charity ) has a relationship with Centcom Charity   My issue is: I am trying to count how many Saved Monthly after the "start date", The code below shows the count before taking a...
DAX
LOOKUPVALUE
measure
  • Jos_Woolley's avatar
    Jos_Woolley
    5 years ago

    Hi,

    Inbound Save =
SUMX (
    Centcom,
    IF (
        'Centcom'[CAMPAIGN] = "Inbound",
        IF (
            'Centcom'[DISPOSITION]
                IN {
                "Saved Monthly Conf. Back.",
                "Saved Monthly Conf. Original",
                "Saved Monthly WLCM back"
            },
            IF (
                RELATED ( Charity[TPV Save] ) = "Yes",
                IF ( Centcom[Date] > RELATED ( Charity[Start Date] ), 1, 0 )
            )
        )
    )
)

    Regards

Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

Inbound Save =
SUMX (
    Centcom,
    IF (
        'Centcom'[CAMPAIGN] = "Inbound",
        IF (
            'Centcom'[DISPOSITION]
                IN {
                "Saved Monthly Conf. Back.",
                "Saved Monthly Conf. Original",
                "Saved Monthly WLCM back"
            },
            IF (
                RELATED ( Charity[TPV Save] ) = "Yes",
                IF ( Centcom[Date] > RELATED ( Charity[Start Date] ), 1, 0 )
            )
        )
    )
)

Regards