Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX

Hello guys,

 I would like to calculate the transformation ratio by doing for example (33/678). could you please help me?

thks.

 

 

5 Replies

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    You can do a couple of measures.(If you don't have [Total ransformations]

    Total Transformations = SUM(Table[Total Transformation])

    Ratio = DIVIDE([Total Transformations], CALCULATE(Sum(Table[Total Transformations]), REMOVEFILTERS()))

    OR

    Ratio = 

    DIVIDE(SUMX(Table, [Total Transformations]),

    SUMX(ALLSELECTED(Table), [Total Transformations]))

     

    I hope this solves your question. Thanks..

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you for your answer I tried both operations and each time I have an error message: The operator or expression '( )' is not supported in this context.

       

       

       

       

      • Whitewater100's avatar
        Whitewater100
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Hi:

        At the end can you write   ...REMOVEFILTERS())

        I beleive I added an extra )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The operation I want to do is divided the column "Gagnée" by the total sum of the column "Total transformation"