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

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

    Hi:

    I tested it. See if we are aligned. I will put two ways of doing the share measure.

    Share 2 = DIVIDE(SUMX(Data, [Total Amt]), SUMX(ALLSELECTED(Data),[Total Amt]))

    Is this a good solution now? Thanks