Forum Discussion
Filters and Calculated Meassures using a fact table with different Dates - (Reservationslist)
NicolasD , there few thing.
First of make all the time relation 1-M single direction.
Second use time intelligence on a measure that already uses userelationship
example
calculate( calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Table'2[CreateDate], 'Date'[Date])),DATESMTD('Date'[Date]))
or
Measure = calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Table'2[CreateDate], 'Date'[Date]))
measure 2=
calculate( [Measure ],DATESMTD('Date'[Date]))
Make sure non of these dates have timestamp, if they have (check by using datatype -datetime and a form that shows time )
If they have to convert to date and join with that column
Date = [datetime].date
when you are using two date slicers, they are filtering data of each other in the table. So check if that can be an issue.