Slicer to work with calculated column in not linked table

[xray_drifter]

Hello, I am a new BI user, so please pardon me if my terminology might not be fully correct.

I have one table as follow:

TABLE1

Name	Date Cardio Exercise	Date Strength Training
John	2/13/2017	2/13/2017
Mike	3/12/2017	1/3/2017
Amy	1/2/2017	3/10/2017
Mary	2/10/2017	1/4/2017
John	3/6/2017	2/5/2017
Mike	1/4/2017	1/5/2017
Amy	2/8/2017	1/8/2017
Mary	3/1/2017	2/3/2017
John	2/14/2017	3/1/2017
Mike	1/2/2017	2/15/2017
Amy	1/15/2017	3/4/2017
Mary	1/7/2017	1/3/2017
John	2/1/2017	2/12/2017
Mike	2/5/2017	1/15/2017
Amy	1/14/2017	1/8/2017
Mary	1/13/2017	2/2/2017
John	3/5/2017	1/2/2017
Mike	3/13/2017	3/8/2017
Amy	3/6/2017	2/8/2017
Mary	2/8/2017	1/4/2017

And i have created a "Dat"e table populates the count the number of occurence of each month

"DATE"

Date (year Month)	Count Cardio Exercise	Count Strength Training
Jan-17	7	9
Feb-17	7	7
Mar-17	6	4

I have created a slicer using the "Name" field of the first table, but that didn't seem to work.   Any ideas?

All advices are appreciated!

[xray_drifter]

In the Date Table, I have added a calculated column as follow:

cardio Count =    calculate(COUNTROWS('BI Test Data'), filter(  'Table1',  'Tabe1'[Date Cardio Exercise]=EARLIER('Date'[Date]) ))

But when I created a slicer using the "Name" field, that didn't seem to change the "cardio count" from the Date table.   Please help!!  I have been stuck with this problem for days... 😞

[Anonymous]

Hi @xray_drifter,

Calculate column not affected by slicer, you need to use measure to instead.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng

[RMDNA]

Hi @xray_drifter,

You're going to want to use a measure, not a calculated column. Give that try.