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"),[Quan​tity_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.
That setting is always grayed out for Measures.
Ok, that makes sense.
But then, why is it returning a blank value? Even when I just select the calculated column, it is still blank.
I don't think smoupre's correct answer has been sufficiently recognized or appreciated here, given the replies after it. The Default Summarization (and Data Category) cannot be set on Measures. I'm not sure whether this is reasonable or not, but it is true. It *does* mirror behavior in Analysis Services MD, so I guess it's reasonable.
The various replies to the OP speak of both columns (including calculated ones) and measures. No idea what's going on if it won't work with the former, but it definitely doesn't work with the latter.
