Forum Discussion

Desj204's avatar
Desj204
New Member
6 years ago

Subtract two counta conditions

Hello,

 

I have a new column that i have the following formula in: 

 
Total Connects = counta(CANDIDATE[Title])-CALCULATE(COUNTA(CANDIDATE[ApplicationStage]),CANDIDATE[ApplicationStage]="Potential Assignee",CANDIDATE[PreStartFallOffReason]="Unresponsive: to Attempts to Follow-up on Next Steps/Status")
 
The 2 conditions work fine on their own, but when i add the subtraction of the first condition from the second condition, it keeps returning the value of the first condition.
 
Any thoughts?
Need Help

2 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago

    I'd need to see sample data to see exactly what is going on, but the first thing I'd try is assigning the values to variables to eliminate any unexpected filtering.

     

    Total Connects =
VAR FirstValue =
    COUNTA ( CANDIDATE[Title] )
VAR SecondValue =
    CALCULATE (
        COUNTA ( CANDIDATE[ApplicationStage] ),
        CANDIDATE[ApplicationStage] = "Potential Assignee",
        CANDIDATE[PreStartFallOffReason] = "Unresponsive: to Attempts to Follow-up on Next Steps/Status"
    )
RETURN
    FirstValue - SecondValue