Forum Discussion
AmiraBedh
Super User
Super UserCalculating the average rate based on specific conditions
I have the following T-SQL query : SELECT (SUM(CASE WHEN DFP.status = 'ON' THEN FVD.metric_rep * FVD.consumption ELSE 0 END) / SUM(CASE WHEN DFP.status = 'ON' THEN FVD.consuption ELSE 0 END...
YourMeasure =
var test =
CALCULATE(SUM(FVD[metric_rep] * FVD[consumption] ), DFP[status] = "ON")
var test2 = CALCULATE(sum(FVD[consuption]),DFP[status] = "ON")
return DIVIDE(test,test2,0)
amirabedhiafi
Impactful Individual
Impactful IndividualYourMeasure =
var test =
CALCULATE(SUM(FVD[metric_rep] * FVD[consumption] ), DFP[status] = "ON")
var test2 = CALCULATE(sum(FVD[consuption]),DFP[status] = "ON")
return DIVIDE(test,test2,0)