TotalMTD doesnt work!!!

[carlos barberis]

Hi friends,
¿is it posible that a PBI function doesnt work?
Attached you will find the exercise of Supercharge Power BI, page 119: Nº 61- [Total Sales Month to Date]
As you can see, figures of Total Sales MTD are equal to Total Sales!!! What I'm doing bad?
The formula used seems OK : Total Sales Month to date = TOTALMTD([Total Sales],'Calendar'[Date])
Thanks in advance
Carlos Barberis

[RamanaV]

Hi,

There is no possibility that a DAX (PBI) function doesn't work.

Your formula is correct.
I think it is a problem with your filters. As I could not understand the language I could not make out what columns you used in filters.

Here is the solution that I got.

Hope it works for you. Otherwise please attach the Power BI workbook. That makes it easy to resolve the issue.

TotalMTD.png (78.03 KiB) Viewed 2223 times

[carlos barberis]

Hi RamanaV

Depite the formula was correct, I eliminale it, I writte it again and the problem was solved. I don't know what happened
Very sorry and very thanks
Carlos