Forum Discussion

uif19085's avatar
uif19085
Helper III
3 years ago
Solved

Calculate Dynamic Ratios

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 foun...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    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

uif19085's avatar
uif19085
Helper III
3 years ago

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's avatar
uif19085
Helper III
3 years ago

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

CALCULATE(COUNT( Artefact[Requirements Selection]))
)" Thanks for your help, i will still accept your input.