Filtering using a measure in Calculate not working

[sailendra]

Hi All,

I am trying to use a "measure" to FILTER a table within CALCULATE (Eg: CALCULATE(count(emp id), FILTER(Table, Column > [measure] ))). This doesn't seem to work.

Actually, I am trying to find the total number of dropouts for any given training. 

For example, When Python is selected.

Step 1: I am looking at the average days to completion by all the employees (7.5).

Step 2: Multiply 2 with Average Time for Completion (as obtained from Step 1). This gives me a threshold (2*7.5 = 15).

Step 3: Filtering the table where "Days since last activity" > 15. This should give me a count as 1 but I'm getting a count of 2. (Refer table)

Request for your kind help.

[amitchandak]

@sailendra , to make measure work as filter you need use some group by or level

example

countx(values(table[emp id]),

CALCULATE(count(Table[emp id]), FILTER(Table,Table[ Column] > [measure] )))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[sailendra]

@amitchandak Thank you. Please use the link to use sample data.

https://1drv.ms/x/s!AvbLSL0qLnNvlUrITGx3l88DPmtZ?e=n2CwgN

[sailendra]

Its the link to Power Bi file as well.

https://1drv.ms/u/s!AvbLSL0qLnNvlUmyFg0DOHDgs0Tq?e=lHkem0

[amitchandak]

@sailendra , Please find the attached pbix, after signature, if that can help

[sailendra]

@amitchandak  Thanks, it helps.