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.
Maybe it is only enabled for columns that it thinks are numeric. If Power BI thinks the column has characters in it, then it disables this as an option?
But even if I pin the column on a report sheet, where it auto sumns it- it returns blank. AND I have changed that column data type to Whole Number.
I have another Model, built exactly like this, off of the same data set- but with different Gropu numbers and ACCT numbers and such- and they work fine. I'm sure its such a simple setting that I'm not picking up on.
