Calculate one measure against the result of another

[Syndicate_Admin]

Hello Community:

Here again I hope you can help me with the next exercise I want to do.

I have a table containing the Market dimension and the Sales and Growth measures. Within the results of growth I have positive and negative values.

Now I need to supplement the table with the information

* Total by type of growth value Negative and positive

* From the previous metric generate the participation metric for the negative and positive.

What I want to get can be seen best in the images I put.

I hope you can help me.

Thanks and regards

[johnt75 · Accepted solution]

You can create a couple of measures like

Venta +/- = CALCULATE( SUM('Table'[Venta]), ALLSELECTED('Table'), SIGN('Table'[Crecimiento]) = SIGN(SELECTEDVALUE('Table'[Crecimiento]) ))

Participacion +/- = DIVIDE( SELECTEDVALUE( 'Table'[Venta]), [Venta +/-])