Forum Discussion

Melmoth's avatar
Melmoth
New Member
10 months ago
Solved

Problem with Total in column (measures)

Hi, first post here!   I am still pretty new to DAX and PowerBI. I see that this is a common issue, yet after a couple of hours of browsing I couldn't find a solution that works for me.   I have ...
  • Melmoth's avatar
    Melmoth
    10 months ago

    Unfortunately it didn't help, however I modified the dashboard quite a bit. I think that the issue is that the slicer was not using the calendar table. Now it works.

     

    So, my recommendation is, if everything else fail, try to use the calendar table as the filter within your slicer.

v-sathmakuri's avatar
v-sathmakuri
Community Support
10 months ago

Hi Melmoth ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Could you please share the sample pbix file where the issue occurs, so that we can work on it and assist you with a solution.

 

Thank you!!

  • Melmoth's avatar
    Melmoth
    New Member
    10 months ago

    Hi v-sathmakuri , unfortunately I can't share the pbix file. It's so strange that just such a simple calculation is taking me so long to figure out. I even tried using SUMMARIZE, SUMX etc. The row by row works, but the total doesn't.

    • v-sathmakuri's avatar
      v-sathmakuri
      Community Support
      10 months ago

      Hi Melmoth ,

       

      I have added the totals column using the M Query. Attached the pbix file for reference. Please let us know if you still have any further questions.

       

      Thanks & Regards,

      Rekha Athmakuri.