Total showing blank in table/matrix visual

[Anonymous]

Hi,

Total showing blank in table/matrix table. What is reason for this. Please check my below DAX Code.

Total Sale = COALESCE( TOTALMTD ( [Sale], dim_clndr[dt] ),0)

[Jihwan_Kim]

Hi,

It is difficult to understand the problem without seeing the datamodel.

I tried to create a sample pbix file like below, and it shows no-blank.

I am not sure what total number you want to show it by using TOTALMTD DAX function, but please try to check what is differently configured.

[Anonymous]

@Jihwan_Kim 

I have created one new  FY column and in that column there is "Current FY" word it change every year automatially and due to "Current FY" total is not showing.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I agree with  Jihwan_Kim's reply, it will be easier for us to find the solution.

I think you can try SUMX() function to have a try.

Sales with Total =
SUMX ( VALUES ( 'TableName'[mnth_nm] ), 'TableName'[Sales] )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

It is difficult to understand what is causing problem without seeing your datamodel.

I guess your fiscal year's ending month is not September.

What is your fiscal year's ending month? And does that month has the data? I think you can check this.