Divide one column by another with a filter

[juliausha]

Hi! 

Does anyone know how to divide one suummarized column by another with a certiain text filter? 

My example: 

I created a matrix for different types of fruits. There's an Action (which is = 'Purchased' or 'Eaten').  For each type of Fruit I want to calculate % of purchased fruits that have been eaten (column 4 in my matrix). 

I would like to create a measure that will translate the following logic: if Action = 'Eaten' then SUM(Items)/ if Action = 'Purchased' then SUM(Items)

Fruit                       Action                                Action                   %

                              Purchased                          Eaten

                              (sum items)                        (sum items)

Apples                  56                                           12                           21.4%

Pears                     40                                           5                              12.5%

Thanks a lot for your help!

[Zubair_Muhammad · Accepted solution]

@juliausha

Try with following

Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Eaten" ),
    CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Purchased" )
)

[juliausha]

Thank you very much @Zubair_Muhammad ! It worked!