Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
9 years ago

Help with COUNT

I'm trying to determine how many opportunities had a "same day turnaround."    I have a calculated column called "Days in queue" which is a datediff.    Then I wrote a measure: #SameDayTurn = CAL...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

I don't see a problem with the formula...

 

#SameDayTurn =
CALCULATE (
    COUNTA ( 'dpmgr vwJMWebSalesEngQueue'[OpportunityID] ),
    'dpmgr vwJMWebSalesEngQueue'[DaysInQueue] = 0
)

How and what did you filter?