topic Re: Can I combine sum total of the countx measure? in DAX Commands and Tips

Can I combine sum total of the countx measure?

Anonymous — Thu, 09 Feb 2023 02:58:33 GMT

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

Re: Can I combine sum total of the countx measure?

tamerj1 — Thu, 09 Feb 2023 10:58:56 GMT

Anonymous
What is the expected result?

Re: Can I combine sum total of the countx measure?

Anonymous — Fri, 10 Feb 2023 10:15:02 GMT

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.

Re: Can I combine sum total of the countx measure?

tamerj1 — Fri, 10 Feb 2023 10:20:28 GMT

Anonymous

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?

Re: Can I combine sum total of the countx measure?

Anonymous — Sun, 12 Feb 2023 13:01:06 GMT

The desired results are displayed in a separate table

Re: Can I combine sum total of the countx measure?

tamerj1 — Sun, 12 Feb 2023 13:15:58 GMT

Anonymous

That is sliced by?

Re: Can I combine sum total of the countx measure?

Anonymous — Sun, 12 Feb 2023 16:35:13 GMT

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

Re: Can I combine sum total of the countx measure?

tamerj1 — Sun, 12 Feb 2023 18:16:49 GMT

Anonymous

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 )
)