Forum Discussion
Measure cannot be filtered by Date Slicer
Community Championowenkosnen sorry, I had an extra bracket at the end of the QoQ%
QoQ% = ( [QTD] - [Last QTR] ) / [Last QTR]
Yes I also noticed the extra bracket there but seems it is the issue...
I am ]curious since my base column for (Table[Amount]) is actually a calculated column, could it be the reason why it is not working ?
- TheoC
owenkosnen it is likely to do with the relationship you have. Have you established a relationship between the Date table and Fact table. Have you got a Date column in both the Date table and Fact table?
TheoC there is only one source table for all data so maybe we can opt out relationship setups.. (though I just learned that the best practice should be to keep Date Table separated)
- TheoC
owenkosnen how are the dates presented in your table? You will need to change the 'Date'[Date] reference in the measures I recommended to your TableName and [Date] column in order for them to work, subject to you have an appropriate Date column.
Hope that makes sense.