Sales Conversion

[Green_G]

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 are against the total IDs. Sorry if this is simple, I'm just starting out with DAX!

Thanks in advance...

[Martin_D · Accepted solution]

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.