The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
@Anonymous
What is the expected result?
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.
@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?
The desired results are displayed in a separate table
@Anonymous
That is sliced by?
Sliced by month, for example if I filter November, it will count how many times the agent has reached the target until November
@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 )
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
115 | |
33 | |
30 | |
24 | |
21 |