Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using Calculate function in column context

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.