Forum Discussion

Green_G's avatar
Green_G
Frequent Visitor
3 years ago
Solved

Sales Conversion

I have a table in the following format:   ID Status 1ABC Quote 2ABC Sold 3XYZ Expired 4EFG Confirmed 5JKL Confirmed   I want to calculate how may confirmed IDs there ar...
  • Martin_D's avatar
    Martin_D
    3 years ago

    Here you are:

     

    % Confirmed = 
DIVIDE (
    CALCULATE (
        COUNTROWS ( VALUES ( 'Table'[ID] ) ),
        KEEPFILTERS ( 'Table'[Status] = "Confirmed" )
    ),
    COUNTROWS ( VALUES ( 'Table'[ID] ) )
)

     

    Selected confirmed percentage of all selected ID

    Formatting as percentage is done in the Measuretools ribbon. You need to click on the Measre in the fields list  to see that ribbon. You need to click on Data in View ribbon to see the fields list.

     

Martin_D's avatar
Martin_D
Icon for Solution Sage rankSolution Sage
3 years ago

Here you are:

 

% Confirmed = 
DIVIDE (
    CALCULATE (
        COUNTROWS ( VALUES ( 'Table'[ID] ) ),
        KEEPFILTERS ( 'Table'[Status] = "Confirmed" )
    ),
    COUNTROWS ( VALUES ( 'Table'[ID] ) )
)

 

Selected confirmed percentage of all selected ID

Formatting as percentage is done in the Measuretools ribbon. You need to click on the Measre in the fields list  to see that ribbon. You need to click on Data in View ribbon to see the fields list.