topic Re: Total Row Not working in DAX Commands and Tips

Total Row Not working

Polar_A — Thu, 06 Jun 2024 09:54:49 GMT

Hi,

I am trying to get the total row to display values at the bottom of my report, but it is not showing anything.

I have a similar measure for all of the other column headings, so if I can determine what is wrong with the totals I can update it for the others.

Please help.

Re: Total Row Not working

Anonymous — Fri, 07 Jun 2024 02:03:23 GMT

Hi Polar_A ,

I don't see from your image that you added this Measure, which may be the reason why you don't see the Total value.

I reproduced your data and added the Measure I created to it.

You can see that the Total value of the created measure is displayed in the Total value.

Best Regards

Yilong Zhou

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

Re: Total Row Not working

Polar_A — Fri, 07 Jun 2024 09:53:03 GMT

Hi Anonymous,

Sorry here is the measure, it was accidentally covered.:

Essentially I want it to filter across the therapy and the referring establishment and count how many are in the respective fields.

Re: Total Row Not working

Anonymous — Tue, 11 Jun 2024 07:49:56 GMT

Hi Polar_A ,

Can you upload your .pbix file please? It's not obvious to me what the problem is with just this one image. It would be nice to be able to upload the .pbix file if you can.

Best Regards

Yilong Zhou

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

Re: Total Row Not working

Polar_A — Thu, 27 Jun 2024 08:39:31 GMT

Hi Anonymous,

Apologies for the delay. Please see attached my file that I am working on.

KR
https://drive.google.com/drive/folders/1sE3X870x98dYRA7VuoPsYjsOtIOJYPvh?usp=sharing