Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Any help appreciated.
Steve
Solved! Go to 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)
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)
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
71 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |