Why is my calculated column ignoring slicers

[quantfinRguy]

To preface, I cannot do a bi-directional relationship between these two data sets due to model complexity so do not suggest that.

I have a date table and a data set.

The data set is composed of columns [Client], [Date], [Measure]. I have a slicer on [Client].

Not all clients have measures on all dates, i.e. one may have measures for July 16 to July 17, while another may have measures from June 14 to July 17. I want to be able to filter a date slicer so that the client that only has measures for July 16 and onwards will only show a timeline for July 16 to July 17 on the slicer, rather than show June 14 to July 17 for any selected client despite a lack of data.

To do so, I created a calculated column in my date table. The calculation is =IF(`date table`[date] IN VALUES(`data set`[date]), [date], BLANK())

I expected my [Client] slicer to filter down the `data set` table, and then the calculated column would display BLANK() for all the dates in the date table not observed for the chosen [Client]. That did not happen. The calculated column is ignoring the [Client] slicer entirely.

How do I fix this? 

[TomMartens · Accepted solution]

Hey,

calculated columns are treated as „normal“ columns by the data model, with the sole difference in clmparison to the othet columns, they do not exist in the data source. For this reason just the normal aggregation functions will show a differing values if the rows of the conaining table are filtered down by the use of slicers.

For this reason you have to define a measure instead of a calculated column.

Regards
Tom