Pareto chart Dax issue - not recognizing column name

[Anonymous]

I have the following DAX formula:

Cumulative ETC = Sumx(Filter(Summarize(Allselected (Data), 'Data'[Porfolio Alignment], 'Data'[Total Estimated Cost], "ETC", 'Data'[Total Estimated Cost], [ETC] >= 'Data'[Total Estimated Cost]), [ETC]).

This works fine to build a table with 3 columns:  Portfolio Alignment, Total Est. Cost, Cumulative ETC. The final column shows the grand total for every row (as expected). Of course to build the Pareto chart I need to have Cumulative ETC actually show a running cumulative total for each row. The problem arises when I try to add the following lines:

1. VAR NewETC = 'Data'[Total Estimated Cost] <<-- here I get an error message "Can not find name '[Total Estimated Cost]'

2. Return 

with both lines 1 & 2 inserted before the Sumx ... followed by a final edit replacing [ETC] >= 'Data'[Estimated Total Cost w/ [ETC] >= New ETC

Why is this happening and how can I fix it?  Thanks in advance for any assistance!

Steve

[Anonymous]

why was this marked as solved ? this did not solve my issue, thanks, Steve

[Anonymous]

Hi @Anonymous ，

Please provide me with more details about your problem. I will try my best to help you.

Best Regards,

Yuna

[Anonymous]

Hi @Anonymous ,

Did you forget to add the closing parenthesis as highlighted above when you creating the "Cumulative ETC" column？

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.