I want one column to be defined by two other columns

[nrungta]

I have one column as EmployeeId, and another column as Month, and another as TargetAchievers, 
TargetAchievers value is 1 if Achieved and 0 if not.
Now the EmployeeId is unique but it repeats monthly.

I want to know how many employees achieved every month successively.
Please help, also I hope this defines my issue completely

[v-diye-msft]

Hi @nrungta 

Let me know if you'd like to get below results:

Measure = CALCULATE(DISTINCTCOUNT('Table'[EmployeeID]),FILTER(ALL('Table'),[TargetAchievers]=1),VALUES('Table'[Month]))

Pbix attached.

[nrungta]

This is not the solution @v-diye-msft 

Taking your version, If you see     

A is TargetAchievers = 1 time

B is TargetAchievers = 2 times

C is TargetAchievers = 2 times

D is TargetAchievers = 3 times

Now as you can see B and C both Achieved 2 times.
The solution I require is where I can click on this number 2 and my whole visualisation drills down on the basis of this, i.e., show drilled data of only B and C.

[nrungta]

Now the Maximum any EmployeeID can get is total 2, then 1 then 0.
There are 2 employees who have got 2, (meaning they have achieved the target successfully in both months).

How do I Visualise my whole other data, just on this number 2, i.e, all other visualisations should drill-down to only these two Employees.

@AlB @Ashish_Mathur 

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[AlB]

@nrungta 

Do show data and an example and everything will be easier and quicker. If you want the number of employees per year:

1. Place year in a table visual

2. Place this measure in the visual (it assumes you want a 1 in all 12 months for the employee)

Measure =
SUMX (
    DISTINCT ( Table1[ID] ),
    INT ( CALCULATE ( SUM ( Table1[TargetAchievers] ) ) = 12 )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[AlB]

Hi @nrungta 

Try this

1. Place Month in the rows of a table visual

2. Place this measure in the visual:

Measure = SUM( Table1[TargetAchievers] )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[nrungta]

Hi @AlB ,
This is not solving my issue. I already have a table for TargetAchievers whose sum will give the same result.
I want to know how many EmployeeIDs achieved the target successively every month,
Suppose in a year it can go Max till 12 only.
How do I drill down all my visuals to the number 12.