Forum Discussion

Green_G's avatar
Green_G
Frequent Visitor
3 years ago
Solved

Sales Conversion

I have a table in the following format:

 

IDStatus
1ABCQuote
2ABCSold
3XYZExpired
4EFGConfirmed
5JKLConfirmed

 

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'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.

     

1 Reply

  • Martin_D's avatar
    Martin_D
    Solution 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.