sum and division calculation for a matrix (in a single measure)

[telesforo1969]

I need to calculate three sums and one division in a single step (Measure)  to create the array shown in the image.

Each month is also calculated (Precio = Costos / Consumos)

[speedramps · Accepted solution]

Thanks for the exmaple picture!

Try this

Create some test data

Create a DAX measure

Answer = 
var myvariable = SELECTEDVALUE(yourdata[Variable])
var x = CALCULATE(SUM(yourdata[Value]), yourdata[Variable] = "Costos")
var y = CALCULATE(SUM(yourdata[Value]), yourdata[Variable] = "Consumos")

RETURN
IF(myvariable = "Precio", 
DIVIDE(x , y),
SUM(yourdata[Value])
)

Draw your matrix 

Please click at least thumbs up for me trying to help.

Then click [accept solution] if it works.

Or provide a better description with input data as table (not a picture)
and example output. 

You will get a quick and better answer with no misunderstandings if you provide clear examples

[speedramps]

@telesforo1969 

I am glad my solution solved your problem.

Please click the thumbs-up and [accept solution] button. 

Thank you !

[speedramps · Accepted solution]

Thanks for the exmaple picture!

Try this

Create some test data

Create a DAX measure

Answer = 
var myvariable = SELECTEDVALUE(yourdata[Variable])
var x = CALCULATE(SUM(yourdata[Value]), yourdata[Variable] = "Costos")
var y = CALCULATE(SUM(yourdata[Value]), yourdata[Variable] = "Consumos")

RETURN
IF(myvariable = "Precio", 
DIVIDE(x , y),
SUM(yourdata[Value])
)

Draw your matrix 

Please click at least thumbs up for me trying to help.

Then click [accept solution] if it works.

Or provide a better description with input data as table (not a picture)
and example output. 

You will get a quick and better answer with no misunderstandings if you provide clear examples

[telesforo1969 · Accepted solution]

Muchas gracias desde México. 
The arrays with the months are no problem. I'll take care of it. Thank you very much.

[ajaybabuinturi]

Hi @telesforo1969,
Could ypu please provide the data how it's looking in Power BI and what type of visual are you going to used.

[telesforo1969]

Thank you. It's a matrix, and I solved it with the proposed "speedramps" code.