Forum Discussion
cdawidow
Helper III
Helper IIIDynamically 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...
daxer-almighty
Solution Sage
Solution SageMost likely your formula like SUM( VALUES( "any column field" ) ) is incorrect. VALUES removes duplicates which means that if you have 2 records in a table that have the same value in the field, the value will only be counted once in SUM. Don't think this is what you'd want.
The rest of the post is not within my grasp.