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 account of the Start Date.

 

Inbound Save = CALCULATE(COUNTROWS('Centcom'), 'Centcom'[CAMPAIGN] = "Inbound",'Centcom'[DISPOSITION] IN {"Saved Monthly Conf. Back.", "Saved Monthly Conf. Original","Saved Monthly WLCM back"} ,Charity[TPV Save] = "Yes")

 

I want the DAX function to count after the Start Date.

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

1 Reply

  • Jos_Woolley's avatar
    Jos_Woolley
    Solution 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