I want compare month wise coverience with total coverience. the measure is as below and its not working

covarience =

VAR N=COUNTROWS(CALCULATETABLE(VALUES('Custom Calendar Table'[Month]),ALLSELECTED('Custom Calendar Table'[Month])))

VAR CurrentAvg=CALCULATE(

AVERAGEX(

VALUES('Custom Calendar Table'[Month]),

[SelectedMeasureType]

),ALLSELECTED('Custom Calendar Table'[Month])

)

VAR PreviousAvg=CALCULATE(

AVERAGEX(

VALUES('Custom Calendar Table'[Month]),

[Previous]

),ALLSELECTED('Custom Calendar Table'[Month])

)

VAR Individual_Month_Covarience=DIVIDE(

([SelectedMeasureType]-CurrentAvg)*([Previous]-PreviousAvg),

)

VAR CovTab=SUMMARIZE('Custom Calendar Table',

'Custom Calendar Table'[Month],

"@cov",Individual_Month_Covarience)

VAR Total_of_AllMonths_Covariance=CALCULATE(SUMX(CovTab,[@cov]))

// how to calclate sum of all Indivisual month covariance

RETURN Individual_Month_Covarience/Total_of_AllMonths_Covariance

// Divide(Individual_Month_Covarience,Total_of_AllMonths_Covariance) to know what portion of the total

// its returnig all 1s when displayed in table with months as row

Forum Discussion

Dax