Calculate Dynamic Ratios

[uif19085]

Trying to find a way to change a ratio calculation with slicer which is having values from a column. 
For example: i have 3 values in a column: apples, pears, oranges and another column where i found which from these fruits are eaten or not, flaged with 1/0.
I want a slicer to select the fruit and get the ratio of that eaten fruit out of total. Total ratio of eaten apples is calculated like this: Total number of eaten apples / Total number of apples. From the slicer i want to change this calculation dynamically for each fruit. 
 

[uif19085]

Hello @Arul , Thank you for your answer. Doesn't seem to work. The result should be 3.76% 

[Arul]

@uif19085 ,

Can you show me the formula what you have use for measure?

Thanks,

Arul

[uif19085]

@Arul 
Sure, but i have to show you the real data tables i use:

Automated Ratio =
VAR Auto = CALCULATE(COUNT(Artefact[Requirements Selection]), Artefact[Automated] = 1)

VAR _all = CALCULATE(COUNT( Artefact[Requirements Selection]), ALL(Artefact))

VAR _result = auto/_all

RETURN

_result
I have a Slicer for Requirement Selection and I marked with 1 which from these are automated

[Arul]

@uif19085 ,

I am not sure about the problem. But, Can you multiply the result with 100 and see?

Thanks,

Arul

[uif19085]

@Arul I've debug a little, and the _all variable doesn't work as intended, it should filter by the slicer value, i've got 1M results for it and the result doesn't change from the slicer , should be 5857

[uif19085]

I've done it. I change _all variable with "

CALCULATE(COUNT( Artefact[Requirements Selection]))

)" Thanks for your help, i will still accept your input. 

[Arul · Accepted solution]

@uif19085 ,

try this in measure,

Ratio of eaten fruit =
VAR _eaten =
    CALCULATE ( COUNT ( Table[Fruits] ), Table[Flag] = 1 )
VAR _all =
    CALCULATE ( COUNT ( Table[Fruits] ), ALL ( Table) )
VAR _result =
    DIVIDE ( _eaten, _all )
RETURN
    _result

Thanks,

Arul