How to get SUM of a Dax Measure

[Anonymous]

Hi,

I have a calculated a DAX Measure. Measure 1 :  (Sum [column1]/Sum[column2])-1, Now i want a Sum od Measure 1. How can i get this value.

Regrads,

Tamil

[Anonymous · Accepted solution]

Hi @Anonymous , 

Check the following result you want.

Total = SUMX ( ALL ( 'Table' ), [Measure 1] )

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @Anonymous ,

A measure itself is a calculation with some kind of summarisation like SUM, AVERAGE, etc.

You will have to define the summation in Measure1 itself in your case.

Just looking at your measure, I can suggest using SUMX rather than SUM in your Measure1.

Give moe details to get the exact solution.

Thanks,

Pragati