Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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?
The desired results are displayed in a separate table
Sliced by month, for example if I filter November, it will count how many times the agent has reached the target until November
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 )
)
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |