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

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

 

Arul's avatar
Arul
Super User
3 years ago

uif19085 ,

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

Thanks,

Arul

  • uif19085's avatar
    uif19085
    Helper III
    3 years ago

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

      uif19085 ,

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

      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