Forum Discussion
Why is my Table Total row blank??
Microsoft EmployeeCan 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
- 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
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] ) )
)