Problem with Total in column (measures)

[Melmoth]

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 a Table Visual with Year, Month, Current Calls, Previous Month Calls (hidden), MoM Change, MoM % Change. I have been able to have the monthly changes). However, of course, the Total doesn't work for some of the columns probably because of the row context of the measures. 

Here's the Visual as of now (The current slicer is set from 8/1/2024 to 9/30/2025, and the user can set any date from 1/1/2020 onward, partial months included).

This is the code for the MoM Change column:

MoM Change = 
// This expression calculates the difference in Calls workload between a month and its previous month
// The expression eliminates the first month, and the prior month.
    VAR DifferenceMoM =
        IF(
            NOT ISBLANK ([CFS_CurrMonthValue]) && NOT ISBLANK([CFS_Previous_Month]), // Do not display values on Matrix if empty                
             [CFS_CurrMonthValue]-[CFS_Previous_Month]
            )
    
    RETURN DifferenceMoM

(in case you're wondering why I have the two NOT ISBLANK statements, it is to avoid the first month (see August) to be filled with the difference with july #'s, and to prevent seing October at the end).

This is the code for [CFS_CurrMonthValue]:

CFS_CurrMonthValue = 
    VAR CurrMonthValue = SUM('Table'[Calls])
    
    VAR CurrMonthValueReturn =
        IF(
            NOT ISBLANK (CurrMonthValue),
                CALCULATE(
                SUM('Table'[Calls]),
                DATEADD('tblCalendar'[Date],0,MONTH)
                )
        )    
        RETURN CurrMonthValueReturn

This is the code for [CFS_Previous_Month]:

CFS_Previous_Month = 
    VAR CurrMonthValue = SUM('Table'[Calls])
    
    VAR PrevMonthValue =
        IF(
            NOT ISBLANK (CurrMonthValue),
                CALCULATE(
                SUM('Table'[Calls]),
                DATEADD('tblCalendar'[Date],-1,MONTH)
                )
        )    
        RETURN PrevMonthValue

One important thing: I use the sum because 'Table'[Calls] is either 1 or 0. If it's is a Call, then it's a 1; otherwise, it's a 0. The table, basically, is as follows:

Ticket (unique id)	Date	Call (1/0)	Closed (1/0)
12345	09/01/2025	1	1
22312	08/05/2025	0	1
12312	09/15/2024	1	0

The % Change column is in a similar situation, no need for me to add it here.

Thank you to whoever can help!

[v-sathmakuri]

Hi @Melmoth ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you!!

[v-sathmakuri]

Hi @Melmoth ,

Could you please let us know if the provided response helped in resolving the issue. If you have any further questions we are happy to address.

Thank you!!

[Melmoth]

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]

Thank you for confirming that using calendar table worked for you.

[v-sathmakuri]

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]

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]

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.