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

Arul's avatar
Arul
Super User
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