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.
Go to Solution.
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")
I believe you'll be able to achieve your desired result with a simpler code.
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.
Hi @AndreT,The formula @GabrielSantos posted is right. Please try it and mark the right reply as answer if you have resolved your issue.Best Regards,Angelia
Thank you, it worked.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.