How to get Sum of Measure

[TamilselviK]

Hi,

I have a Measure ex : Measure 1 : (Sum[Column1]/Sum[Column2])-1 ,Now i want to get Sum[Measure1] something like this. How can i get this.

Regards,

Tamilselvi K 

[amitchandak]

@TamilselviK , I think some text or image is missing after "Now i want to get Sum[Measure1] something like this"

Please share

Additionally, prefer to use divide

Measure 1 = divide(Sum[Column1]),Sum[Column2]))-1

or

Measure 1 = divide(Sum[Column1])-Sum[Column2]),Sum[Column2]))

[TamilselviK]

Hi,

I have Changed my measure as you said Measure 1 : Divide(Sum[Column1],Sum[Column2])-1.

My ask is how to get Sum of Measure1. I can't use SUM function because it expects Column Name. 

Regards,

Tamilselvi K

[amitchandak]

@TamilselviK , for that you need a grouping column  from your table

sumx(values(Table[column]),[Measure1])

Usually, column is axis/row or legend of visual or the level of details