Forum Discussion

Melmoth's avatar
Melmoth
New Member
11 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.

Melmoth's avatar
Melmoth
New Member
11 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
Icon for Community Support rankCommunity Support
11 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.