Measure DAX

Anonymous — Wed, 11 Aug 2021 17:11:24 GMT

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.

Re: Measure DAX

Jos_Woolley — Wed, 11 Aug 2021 18:41:09 GMT

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

topic Re: Measure DAX in DAX Commands and Tips

Measure DAX

Re: Measure DAX