CALCULATE doesn't work with measure in a table

[MCacc]

Hello, 

I don't know why but my measure returns blank.

CALENDAR is a table made of distinct values of my TABLE_FACTS[REFERENCE_DATE]. I then use the field DATE_FILTER in a slicer.

I also have two additional filters, that come from two dummies tables, wich are basically the distinct values of two dimensional columns I have in my TABLE_FACTS.

This is my measure:

VAR DATE_SELECTED = SELECTEDVALUE(CALENDAR[DATE_FILTER]

RETURN 

CALCULATE(SUM(TABLE_FACTS[VALUE]), 

         FILTER(TABLE_FACTS, TABLE_FACTS[REFERENCE_DATE] = DATE_SELECTED)

)

This measure is used in a table, and in this table I have three other dimension. 

The measure doesn't work either if the tables are in a relationship or not. I also tried to use ALL(TABLE_FACTS) but it doesn't work.

What I getting wrong?

Thanks for your help

[PhilipTreacy]

Hi @MCacc 

I suspect it's something to do with the way your are working with the dates.  You should be using a proper date table.

Please supply your file so I can see the data, hard to figure this out without seeing the data.

Phil