Forum Discussion
Default Summarization
Caitlin_Knox - Perhaps a data type issue with your calculated column? Generally that would return an error though in a measure, for example trying to SUM a text column. Grasping at straws here.
What if you try an equivalent measure without the column:
Sum2 of S2473 - 00201 = SUMX(FILTER(tbl_FixedCost,[Client_Code]="S2473" && [ACCT]="00201"),[Quantity_Enrolled])
Technically probably a better way to do what you are doing since it avoids the extraneous calculated column and all of the logic is contained within the filter. Essentially what this is doing is returning a table filtered down to just the Client_Code and ACCT that you want and then summing Quantity_Enrolled for only those rows. Should be 100% equivalent to your method. Just curious about whether eliminating that calculated column does anything.
Caitlin_Knox - Perhaps a data type issue with your calculated column? Generally that would return an error though in a measure, for example trying to SUM a text column. Grasping at straws here.
What if you try an equivalent measure without the column:
Sum2 of S2473 - 00201 = SUMX(FILTER(tbl_FixedCost,[Client_Code]="S2473" && [ACCT]="00201"),[Quantity_Enrolled])
Technically probably a better way to do what you are doing since it avoids the extraneous calculated column and all of the logic is contained within the filter. Essentially what this is doing is returning a table filtered down to just the Client_Code and ACCT that you want and then summing Quantity_Enrolled for only those rows. Should be 100% equivalent to your method. Just curious about whether eliminating that calculated column does anything.
Thank you for your suggestions.
I got so frustrated yesterday, I started over. And now it works. Unfortunate that I can't pinpoint what went wrong, but am glad its working now.
You're right, that is a much better way to perfom a SUM operation, thanks for the tip.