topic Re: Total showing blank in table/matrix visual in DAX Commands and Tips

Total showing blank in table/matrix visual

Anonymous — Fri, 03 Nov 2023 04:23:19 GMT

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)

Re: Total showing blank in table/matrix visual

Jihwan_Kim — Fri, 03 Nov 2023 04:58:08 GMT

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.

Re: Total showing blank in table/matrix visual

Anonymous — Fri, 03 Nov 2023 05:13:07 GMT

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.

Re: Total showing blank in table/matrix visual

Jihwan_Kim — Fri, 03 Nov 2023 05:28:53 GMT

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.

Re: Total showing blank in table/matrix visual

Anonymous — Mon, 06 Nov 2023 09:29:36 GMT

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.