Why is my Table Total row blank??

[PB797]

[mahoneypat]

Can you share the measure you are using? I suspect there is a function (e.g., SELECTEDVALUE) or logic that is return blank in the "total" row. Please @ mention me in the response so I see your reply.

Pat

[PB797]

@mahoneypat 

Adjustments_Month_to_Date = CALCULATE(SUM(Query1[ActivityAmount]),DATESMTD('Calendar'[Date]))

[mahoneypat]

In the "total" row, there is no filter on date, so it is seeing the entire Calendar table and the DATESMTD function is returning the dates in the last month of the year. As that hasn't happened yet, you likely don't have any matching rows in your table, so it appears as a blank.

Have you tried a simpler DAX expression? The DATESMTD may not be necessary. Perhaps just

SUM(Query1[ActivityAmount])

You would likely see the expected total. If you do need the DATESMTD, you can get the expected total with an expression like this as described in this video - Power BI - Tales from the front #01 - Getting the Right Total - YouTube

New SUM MTD =
SUMX (
VALUES ( 'Calendar'[Month] ),
CALCULATE ( SUM ( Query1[ActivityAmount] ), DATESMTD ( 'Calendar'[Date] ) )
)

Pat

[PB797]

Sorry for the Delay in my response, I tried using the below DAX expression that you suggested and am getting an error message stating the Column Month could not be found. This is odd as I have it in my Calendar table and it is even selected to create the visual. 

 New SUM MTD =
SUMX (
VALUES ( 'Calendar'[Month] ),
CALCULATE ( SUM ( Query1[ActivityAmount] ), DATESMTD ( 'Calendar'[Date] ) )
)