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 ,

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

      • 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.