Forum Discussion
Default Summarization
- 10 years ago
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.