Forum Discussion
Dynamically Using SUM X for allselected values
Hi guys I have a simple measure called Average Sales = AVERAGEX(VALUES(FISCAL YEAR),TOTAL SALES)) Which is essentially calculating the average of total sales across all present years. The formu...
[Sum of Avg Sales Over Column] =
SUMX(
DISTINCT( Dimension[Column] ), // use VALUES if you've got RI problems
CALCULATE(
AVERAGE( FactTable[Sales Amount] )
)
)
// HASONEVALUE is redundant in
// your code since if there's only
// one T[Column] value visible
// in the current context, SUMX
// will sum up over just one value.