Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

What's wrong with this formula?

Hi, I just wanted to check what is wrong with this formula?   Closed with Task = OR(CALCULATE(DISTINCTCOUNT(Task[Job ID (Task) ]),'Task'[Job.Status__c]="Closed"), CALCULATE(DISTINCTCOUNT(Task[Job ...
Need Help
  • GabrielSantos's avatar
    GabrielSantos
    8 years ago

    Ah, got ya.

     

    I believe this will work:

     

    DistinctCount.Open.PaymentEntry = CALCULATE(
                                             DISTINCTCOUNT( Task2[Job_ID] ),
                                                    FILTER( Task2 ,
                                                               Task2[Job_Status] = "Closed"
                                                           ||  Task2[Job_Status] = "Payment Entry")
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago
Hey,
It would work only if all tasks had unique job id. Because there are jobs with mulitple taks I have to use distinct count.
GabrielSantos's avatar
GabrielSantos
Resolver I
8 years ago

Ah, got ya.

 

I believe this will work:

 

DistinctCount.Open.PaymentEntry = CALCULATE(
                                             DISTINCTCOUNT( Task2[Job_ID] ),
                                                    FILTER( Task2 ,
                                                               Task2[Job_Status] = "Closed"
                                                           ||  Task2[Job_Status] = "Payment Entry")
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you, it worked.