Calculated Measures and CPMU calculations

[SteveKingdon]

Hi,

I am new here and to BI, and I am looking for some help.

I am trying to use a calculate measure to calculate a complaints per million units figure.

One of the values being used is pulled form an SQL report and the other is a calculated measure I have set up. How ever I can not see the calculated measure when using the DAX formula to create the CPMU calculation.

My question is can you use a calculated measure in another calculated measure or is this to complex?

If you can not how can I calculate one number to then be used in a further calculation.

The CPMU calculation I am using is 

CPMU = divide(sum(Complaints[Number Of Complinats]),divide(sum(calculated measure),1000000))

Any help appreciated.

Steve

[V-lianl-msft · Accepted solution]

Please try :

CPMU = 
var divide_1 = divide(calculated measure,1000000)
return divide(sum(Complaints[Number Of Complinats]),divide_1)

 If you want to sum measure, use sumx instead of sum.

CPMU = 
var divide_1 = divide(SUMX ( VALUES ( Complaints[xxxx] ), [calculated_measure] ),1000000)
return divide(sum(Complaints[Number Of Complinats]),divide_1)