Days difference between two date in a measure

[Anonymous]

Hello Everyone!!

I am trying to calculate a measure in which i am trying to calculate date difference between two coloumns that are present in seperate diffrent tables in star schema. One is date Dimension in which last date of each month is present and the other is accumulating fact table in which dates are present with respect to work flow.
Now what I am trying to do is to get date difference of one date coloumn from fact table to that of data coloumn from date dimension. 
currently i am using this dax farmula

DATEDIFF(max('Date dimension'[Date]),SELECTEDVALUE('fact table'[Rc Date]),DAY), ALL('Date dimension'),

'fact table'[Employee Key] in Employee,'fact table'[rc month] >=7 , 'fact table'[rc month]<= MaxDate , 'fact table'[Rcm Date] = BLANK())

which is giving me wrong result
kindly help me out .

[amitchandak · Accepted solution]

@Anonymous , Is the date table joined with Fact RC date ?

Because then it will same date

In a measure to take a date diff you need three thing

1 . Min of smaller date

2. Max of bigger date 

3. A common group by (In this case it may be an Id from fact), That is forced using values or summarize 

refer to my blog - https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.