Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Measure DAX

kelvinbala_2-1628694397632.png

 

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.

1 ACCEPTED SOLUTION
Jos_Woolley
Solution Sage
Solution Sage

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

View solution in original post

1 REPLY 1
Jos_Woolley
Solution Sage
Solution Sage

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.