Using Calculate function in column context

[Anonymous]

Hi 

I have a Data model of Employees, that is to be classified into Age Groups defined in a separate Dimension Table. I can calculate the Age group of the Employee from DOB. But I need to do distinctCount on EmployeeID in the Dimension Table ...bcoz I need to filter the Employee table on the value referred in Dim Age-group tbl. 

I am using Calculate function in a Column added to the Dim Age-group table & using filter function in it for the Date conditions. This gives me the correct values. The only issue here is when I place a Slicer with some different Dimension. The values aren't getting filtered out as Calculate ignores Filter context. 

CALCULATE(DISTINCTCOUNT('EMP'[ID]),
                        filter('EMP', 
                       // date filters                       
                     && 'tx Worker'[Age-group] = 'Age-Group'[Age-group]))

Can you please help me How can I get the values filtered by Slicer also?

Thanks

Apoorv

[Anonymous]

Calculated columns get loaded at first load only.

They can't change with slicer selection.

if you want something dynamic, need to create measures.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.