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.
My data model has 2 external lists from sharepoint that are queried from the sql database, and 2 tables of check register data that are inserted from excel spreadsheets.
I have another report I'm working on from the exact same model that I do not have this issue with.
The measure in question is based on a calculated column from one of the external lists- Fixed Cost List. Information is inputted from a billing statement which includes enrollment numbers. The column parses out the enrollment quantity for a given client and account- by using IF AND statement. Like I said before, I can visually see that it returns teh values correctly in the column- but when I go to grab it on a report sheet it returns blank. The column and the measure are built on the same table.
The issue seems to be isolated to this one table. I have measures on other tables that return values.
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.
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.