I'm facing an issue with TOTALMTD, TOTALQTY DAX functions.
Here is my problem,
I have 2 tables,
one is Dimension table for Date and another one is fact. There is a relationship between them based on Date field.
I have created a measure - TOTALMTD(SUM(fact[Sales]),Dimension[Date]))
It isn't working as expected. But when use Fact[Date] instead Dimension[Date] or Remove the relationship, It's working fine.
It's absolutely strange. Kindly help me with this.
Check weather the date field in the fact table and date field in the dimension table is of same data type.
Earlier I also faced the same issue then I found out that in my fact table date was stored in datetime format and in my calender table date was stored as the type of date format
Thanks for the quick response. Both are in the same data type(Date).
can u share the relationship diagram?
i'm having the same issue, did you find any solution on that one ?
thank you !!!
Create two new tables.
In the first table, pull in your date and sales total, both from your LiquorSales data.
Second table, pull in your date column from your Dates_modelview and sales total from your LiquorSales.
Narrow both down to just this month and compare results. If your "TotalMTD" is wrong, these two tables should not match. This will help you find the issue.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!