Finding the Total of a Calculated Field

[bigbadbrad]

I am trying to use the Total of a calculated field column i created as the denominator in another calculated field. So i have a calculated field that is calculating the unique sum:

"[UniqueDemand] =SUMX(DISTINCT(KWfile[Keyword]), [MaxDemand])".

This formula works great for what i am doing. But what i would like to do now is take the total of [UniqueDemand] and use it in the denominator of another equation to get the % of total from a different field.
I don't seem to be able to just use a simple

"SUM([UniqueDemand])", i guess because it is a calculated field I get a formula error? And when i try to do something like:

"SUMX(ALL(KWfile), [UniqueDemand])" i get the wrong result,

for some reason i get a total but the total i get now has duplication i removed in the [UniqueDemand] equation?
I'm stumped, seems like i am so close i just can't seem to calculate the total of [UniqueDemand] so i can use it in another equation. Anyone have any ideas?

 

[bigbadbrad]

Alright, figured it out:

Calculate(KWfile[UniqueDemand],All(KWfile))

This formula will give me the correct total of my calculated [UniqueDemand] field. Not entirely sure why Calculate() works and the SUMX() formula does not (guessing just the iterative processing of the SUMX was not doing what i thought in that case). Still figuring out DAX but slowly getting what i need...