Calculated Table (No total in columns)

[Anonymous]

Im having this issue where im trying to aggregate some data into a calculated table. Im brining in customer name & and some measures for some columns. 

The table is forming correctly without an issue, but when i construct a table on the report page columns are not showing a total at the bottom. 

Measeures: Data Type: Decimal Number, Summarization:Sum, Format:Decimal number

DataFlow.Summary = SUMMARIZE('11_Accounts_Master','11_Accounts_Master'[GUID],'11_Accounts_Link'[Customer Name],


"FY20 A", 
[FY20 A],




"FY21 A", 
[FY21 A],



"FY21 E", 
[FY21 E])

What do you think could be the issue? 

Thank you & Kr

[Anonymous · Accepted solution]

Good day @amitchandak ,

Do you need further explanation on issue that i could provide?

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
When you create a table visual on the report, you can enable and disable the total field.
Appreciate your Kudos.

[Anonymous]

Hey Amit,

Thanks for helping out again. 

Of course let me make a screenshot on another similar example. If you look below, you can see that Min is displaying the total at the bottom of the table and MAX is not, both have same exact setting terms of formatting. I dont understand why the behavior is diffrent. 

Thank you & regards

[Anonymous]

Hi @Anonymous ,

I can't reproduce your problem. The field %Change.close.clac is a default one in table or calculated column? If it is a calculated column, could you please provide its formula and data type? Thank you.

Best Regards

[Anonymous]

@Anonymous 

Thank you very much for your time to look into my issue. Sorry for the delay. 

Yes, %Change.close.Clac is a calculated column. Some how now i get the totals at the bottoms of the table. I amnot sure what i did. I think nothing. Maybe when i restarted my PC ? But im anyways including the measure code below in case you want to still have a look. 

%Change.close.Clac = IFERROR(('22_Price_Daily'[Get_Price.Column1.close] - '22_Price_Daily'[PRV.DAY.Close.custom])/'22_Price_Daily'[PRV.DAY.Close.custom],BLANK())

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please check whether the field [MAX] be set as "Don't summarize" as shown in below screenshot when drag onto table visual?

Any comment or problem, please feel free to let me know.

Best Regards

[Anonymous · Accepted solution]

Good day @amitchandak ,

Do you need further explanation on issue that i could provide?