DAX

[Anonymous]

Hello guys,

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

thks.

[Anonymous]

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

[Whitewater100]

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]

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]

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

[Whitewater100]

Hi:

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

I beleive I added an extra )