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 ID (Task) ]),'Task'[Job.Status__c]="Paymnet_Entry"))

Want to count jobs which either are closed or are in payment_entry status.

 

After entering this forumla I don't get any results at all.

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")
)

5 Replies

  • GabrielSantos's avatar
    GabrielSantos
    Resolver I
    8 years ago

    Hey there!

     

    I believe you'll be able to achieve your desired result with a simpler code. 

     

    Try this:

     

    Count Closed.PaymentEntry = COUNTROWS(
                                       FILTER( Task ,
                                                   Task[Job_Status] = "Closed"
                                               ||  Task[Job_Status] = "Payment Entry" )
)

    In short, we use the countrows function to count the rows of a table that we filter to only include rows with "Closed" or "Payment Entry" job statuses. The || is the "or" operator.

     

     

    • 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")
)