Get help with "Contracted Bids" is what % of "Total Bids" for each Vendor

[redcof]

The data table is one bid per record.

For each Vendor, want to calculate what % of "Total Bids" is "Contracted Bids".

My attempts with a calculated column resulted in 2 rows per Vendor, one with 0% and one with 100%.

Thanks.

[v-yiruan-msft]

Hi @redcof ,

You can create a measure as below if both Contracted Bids and Total Bids are measure, then select the measure and set the format as Percentage just like below screenshot:

Measure = DIVIDE ( [Contracted Bids], [Total Bids], 0 )

If the above measure can't return the correct result, please provide some sample data with Text format and your expected result with example. Thank you.

Best Regards

[redcof]

The raw data has a column "Status Reason", with three possible entries:

Contracted

Rejected

Open

I added 4 calculated columns:

Contracted Bids = if('RFP Submittal Advanced Find'[Status Reason] = "Contracted", 1, 0)
Rejected Bids = if('RFP Submittal Advanced Find'[Status Reason] = "Rejected", 1, 0)
Open Bids = if('RFP Submittal Advanced Find'[Status Reason] = "Open", 1, 0)
Total Bids = 'RFP Submittal Advanced Find'[Contracted Bids]+'RFP Submittal Advanced Find'[Rejected Bids]+'RFP Submittal Advanced Find'[Open Bids]
 So each row will have a "1" in one of the first three columns and a "0" in the other two, and a "1" in the "Total Bids" column.

The table on the report sums them for each vendor.
Currently I have:
% Awarded = ('RFP Submittal Advanced Find'[Contracted Bids])/('RFP Submittal Advanced Find'[Total Bids])
 

[v-yiruan-msft · Accepted solution]

Hi @redcof ,

In fact, you don't need to create the above four calculated columns, you can only create one measure as below to get % Awarded:

% Awarded 2 = 
VAR _contracted =
    CALCULATE (
        COUNT ( 'RFP Submittal Advanced Find'[Status Reason] ),
        FILTER (
            'RFP Submittal Advanced Find',
            'RFP Submittal Advanced Find'[Status Reason] = "Contracted"
        )
    )
VAR _totalpvendor =
    CALCULATE (
        COUNT ( 'RFP Submittal Advanced Find'[Status Reason] ),
        ALLEXCEPT (
            'RFP Submittal Advanced Find',
            'RFP Submittal Advanced Find'[Vendor]
        )
    )
RETURN
    DIVIDE ( _contracted, _totalpvendor, 0 )

Best Regards

[redcof]

@v-yiruan-msft Thank you so much!!