topic Re: Dax Count number of bids submitted filtered by status in DAX Commands and Tips

Dax Count number of bids submitted filtered by status

eilidh3 — Tue, 26 Jul 2022 14:03:51 GMT

Hi all,

I think this is a fairly simple one but I must have something slightly off.... or maybe I'm way off!!

I'm looking to create a hit rate... I have my bids submitted number (which only includes bids with a submitted date) but would like to create a measure of successful bids submitted.

Successful bids = Pipeline Status = Preferred Bidder OR Contract Award OR Status = Won.

The below isnt working....

No of Bids Successful = Calculate(

COUNTA(Opportunities[Bid Submitted Date]),

FILTER(Opportunities, Opportunities[ID_Pipeline Reporting Status] = "Preferred Bidder" || Opportunities[ID_Pipeline Reporting Status] = "Contract Award))

Opportunity Name	Bid submitted date	Pipeline Status	Status
Opportunity 1	17/01/2022	Preferred Bidder	Open
Opportunity 2	18/01/2022	Contract Award	Won
Opportunity 3		Preferred Bidder	Open
Opportunity 4	19/01/2022	Bid Submitted	Open

Any help much appreciated as always 🙂

Re: Dax Count number of bids submitted filtered by status

tamerj1 — Tue, 26 Jul 2022 15:21:31 GMT

Hi eilidh3

your code assumes unique opportunity names therefore I assume the same. Please try

No of Bids Successful = COUNTROWS ( FILTER ( Opportunities, Opportunities[Bid submitted date] <> BLANK () && OR ( Opportunities[ID_Pipeline Reporting Status] = "Preferred Bidder", Opportunities[ID_Pipeline Reporting Status] = "Contract Award" ) ) )

Re: Dax Count number of bids submitted filtered by status

Anonymous — Mon, 08 Aug 2022 06:12:42 GMT

Hi eilidh3 ,

Did some edits based on tamerj1's formula.

No of Bids Successful = COUNTROWS ( FILTER ( Opportunities, Opportunities[Bid submitted date] <> BLANK () && ( Opportunities[ID_Pipeline Reporting Status] = "Preferred Bidder" || Opportunities[ID_Pipeline Reporting Status] = "Contract Award" || Opportunities[Status] = "Won" ) ) )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data