Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, I'm creating a Attendance Points report on Power Bi, the points are being assesed correctly but I can't get a summary for each agent. Can someone assist?
*Time Missed*
As you can see on the screenshot, the point are being assesed correctly I cant see how many points does the agent have as of today (including everything earned)
I know this
Solved! Go to Solution.
Hi @davidjimenez18 ,
Total Cumulative Points 4 =
VAR _a =
SUMMARIZE (
'FACT_Scheduled Activities',
'FACT_Scheduled Activities'[Agent Name],
[Date],
"c",
CALCULATE (
SUMX (
VALUES ( 'FACT_Scheduled Activities'[Date] ),
[Attendance Points Assesments]
),
FILTER (
ALLSELECTED ( 'FACT_Scheduled Activities'[Date] ),
'FACT_Scheduled Activities'[Date]
<= EARLIER ( 'FACT_Scheduled Activities'[Date] )
)
)
)
VAR _b =
SUMX ( _a, [c] )
VAR _c =
SUMX (
SUMMARIZE (
CALCULATETABLE (
'FACT_Scheduled Activities',
FILTER (
ALLSELECTED ( LKUP_Dates[Date] ),
[Date] <= SELECTEDVALUE ( LKUP_Dates[Date] )
)
),
[Agent Name],
[Date],
"c",
CALCULATE (
[Attendance Points Assesments],
FILTER (
ALL ( LKUP_Dates ),
[Date] <= EARLIER ( 'FACT_Scheduled Activities'[Date] )
)
)
),
[c]
)
RETURN
IF (
HASONEVALUE ( 'FACT_Scheduled Activities'[Date] ),
IF ( ISBLANK ( [Attendance Points Assesments] ), BLANK (), _c ),
_b
)
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@davidjimenez18 , Try like
Total Cumulative Points =
CALCULATE (
sumx(values('DEO_TU_Sch'[Date]), [Attendance Points Assesments]),
FILTER( ALLSELECTED( DEO_TU_Sch[Date] ),
'DEO_TU_Sch'[Date] <= Max('DEO_TU_Sch'[Date])
)
)
Thank you for your response @amitchandak, maybe I'm doing something wrong. I see total are now summing on the Matrix Table only on the first row but not on the actual points. Do you think it could be an error on the formulas that I have or maybe a data error?
@davidjimenez18 , try like
Total Cumulative Points =
CALCULATE (
sumx(values('DEO_TU_Sch'[Date]), [Attendance Points Assesments]),
FILTER( ALLSELECTED( DEO_TU_Sch),
'DEO_TU_Sch'[Date] <= Max('DEO_TU_Sch'[Date])
)
)
or better to have joined date tbale
Total Cumulative Points =
CALCULATE (
sumx(values('DEO_TU_Sch'[Date]), [Attendance Points Assesments]),
FILTER( ALLSELECTED( Date ),
'Date'[Date] <= Max('Date'[Date])
)
)
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hey @amitchandak,
Here is a report sample to see if you can help me further. I would love it if you could help me as well on the "Point Assessment" for the NCNS because the system is assessing 5 points instead of 4 on the formula.
I have created 3 pages 1 with each calculation. Thank you again for your help!
https://www.dropbox.com/s/vbtjp89ygz6wjdg/Report%20Sample.pbix?dl=0
Hi @davidjimenez18 ,
Is this you want?
Maybe you can try this code:
Total Cumulative Points 4 =
VAR _a =
SUMMARIZE (
'FACT_Scheduled Activities',
'FACT_Scheduled Activities'[Agent Name],
[Date],
"c",
CALCULATE (
SUMX (
VALUES ( 'FACT_Scheduled Activities'[Date] ),
[Attendance Points Assesments]
),
FILTER (
ALLSELECTED ( 'FACT_Scheduled Activities'[Date] ),
'FACT_Scheduled Activities'[Date]
<= EARLIER ( 'FACT_Scheduled Activities'[Date] )
)
)
)
RETURN
SUMX ( _a, [c] )
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @v-chenwuz-msft , Yes, that solves one of my questions, thank you.
The other one is that I need the points to be accumulated as the come.
Hi @davidjimenez18 ,
Total Cumulative Points 4 =
VAR _a =
SUMMARIZE (
'FACT_Scheduled Activities',
'FACT_Scheduled Activities'[Agent Name],
[Date],
"c",
CALCULATE (
SUMX (
VALUES ( 'FACT_Scheduled Activities'[Date] ),
[Attendance Points Assesments]
),
FILTER (
ALLSELECTED ( 'FACT_Scheduled Activities'[Date] ),
'FACT_Scheduled Activities'[Date]
<= EARLIER ( 'FACT_Scheduled Activities'[Date] )
)
)
)
VAR _b =
SUMX ( _a, [c] )
VAR _c =
SUMX (
SUMMARIZE (
CALCULATETABLE (
'FACT_Scheduled Activities',
FILTER (
ALLSELECTED ( LKUP_Dates[Date] ),
[Date] <= SELECTEDVALUE ( LKUP_Dates[Date] )
)
),
[Agent Name],
[Date],
"c",
CALCULATE (
[Attendance Points Assesments],
FILTER (
ALL ( LKUP_Dates ),
[Date] <= EARLIER ( 'FACT_Scheduled Activities'[Date] )
)
)
),
[c]
)
RETURN
IF (
HASONEVALUE ( 'FACT_Scheduled Activities'[Date] ),
IF ( ISBLANK ( [Attendance Points Assesments] ), BLANK (), _c ),
_b
)
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |