Forum Discussion

Polar_A's avatar
Polar_A
Helper I
2 years ago

Total Row Not working

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.

KR

 

 

DAX BUG
Show and Tell
Tutorial

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • Polar_A's avatar
      Polar_A
      Helper I
      2 years ago

      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.

       

      KR

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.