Calculated measure from SUM of measure

[hitesh1607]

I have a table with Column A and 2 calculated measures. Need to divide the sum of measure 1 by measure 2 each row result

Column A	Measure 1 (This is derived from using SUMX ( values))	Measure 2	Measure 3 (This needs to be calculated)
a	10	100	100/ Total of measure 1
b	20	200	200/ Total of measure 1 (60)
c	10	300
d	20	400
	60

[Jihwan_Kim · Accepted solution]

Hi, @hitesh1607 

Please try the below measure

measure3 =
DIVIDE (
Measure2,
CALCULATE ( Measure1, ALLSELECTED ( Table[CoumnA] ) ),
BLANK ()
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.