Forum Discussion

manish_tripathi's avatar
manish_tripathi
Frequent Visitor
3 years ago
Solved

Count with multiple conditions

I have a table where i have User email (as text), Bidstatus (as text) and Bid created date (in Datetime format)   where i am counting the interviewed talent using the following measure   Intervi...
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    manish_tripathi , Try like

     

    Interviewed Talent =
    CALCULATE(
    COUNTA('Bids made by HEB'[BidStatusName]),filter('Bids made by HEB' ,
    'Bids made by HEB'[BidStatusName] in { "Back Out", "Credentialing","Interview Rejected" ,"Interview Pending", "Interview Scheduled", "Customer Interview", "On Billing", "Drop" }&& 'Bids made by HEB'[Created]< date(2022,11,01) )
    )

amitchandak's avatar
amitchandak
Super User
3 years ago

manish_tripathi , Try like

 

Interviewed Talent =
CALCULATE(
COUNTA('Bids made by HEB'[BidStatusName]),filter('Bids made by HEB' ,
'Bids made by HEB'[BidStatusName] in { "Back Out", "Credentialing","Interview Rejected" ,"Interview Pending", "Interview Scheduled", "Customer Interview", "On Billing", "Drop" }&& 'Bids made by HEB'[Created]< date(2022,11,01) )
)