Using Calculate function in column context

Anonymous — Fri, 24 Jan 2020 12:56:29 GMT

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

Re: Using Calculate function in column context

Anonymous — Fri, 24 Jan 2020 13:25:49 GMT

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.

topic Re: Using Calculate function in column context in DAX Commands and Tips

Using Calculate function in column context

Re: Using Calculate function in column context