Can I combine sum total of the countx measure?

[dickyalsyah]

Hello master,

I've got stuck when I want to calculate the sum for the measure. Can I add up the sum of the achievements with conditions of more than 6 months and a variance of more than 100%.

And this is my achievement measure :

Achievement = COUNTX(VALUES('Emp Data'[Emp ID]), if([Variance %] >= 1, [Emp ID], BLANK()))+0

Thanks you

[tamerj1]

@dickyalsyah 
What is the expected result?

[dickyalsyah]

I want to know the achievement of the sales agent reaching the target every month, example sales agent A in 1 year has reached the target (>= 100%) in 6 times.

[tamerj1]

@dickyalsyah 

Ok but how are you planing to display this result? At the total row of the matrix (column totals) or in a separate table or in a card visual?

[dickyalsyah]

The desired results are displayed in a separate table

[tamerj1]

@dickyalsyah 

That is sliced by?

[dickyalsyah]

Sliced by month, for example if I filter November, it will count how many times the agent has reached the target until November

[tamerj1]

@dickyalsyah 

Please try

Count Achievements Above 100% =
SUMX (
FILTER (
CROSSJOIN ( VALUES ( 'Emp Data'[Emp ID] ), ALL ( 'Date'[Month] ) ),
'Date'[Month] <= SELECTEDVALUE ( 'Date'[Month] )
),
IF ( CALCULATE ( [Achievement], 'Date'[Month] = 'Date'[Month] ) >= 1, 1 )
)