Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi,
Please help to create measure to get the sum of average of LC from individual employee id.
Count of Employee ID | Sum of LC (Culculated Measure) | |||
Emp ID | Count of Day | Sum of LC Final | Average LC per month | |
258589 | 21 | 0.395428571 | 0.018829932 | =C3/B3 |
280948 | 9 | 0.446857143 | 0.049650794 | =C4/B4 |
sum of average | 0.068480726 |
Solved! Go to Solution.
Hi @ssk_1984 ,
I suggest you to try code as below.
Average LC per month =
VAR _VirtualTable =
ADDCOLUMNS (
SUMMARIZE (
'Table',
'Table'[Emp ID],
"Count of Day", CALCULATE ( COUNT ( 'Table'[Day] ) ),
"Sum of Final", CALCULATE ( SUM ( 'Table'[LC Final] ) )
),
"Avg", DIVIDE ( [Sum of Final], [Count of Day] )
)
RETURN
SUMX ( _VirtualTable, [Avg] )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ssk_1984 ,
I suggest you to try code as below.
Average LC per month =
VAR _VirtualTable =
ADDCOLUMNS (
SUMMARIZE (
'Table',
'Table'[Emp ID],
"Count of Day", CALCULATE ( COUNT ( 'Table'[Day] ) ),
"Sum of Final", CALCULATE ( SUM ( 'Table'[LC Final] ) )
),
"Avg", DIVIDE ( [Sum of Final], [Count of Day] )
)
RETURN
SUMX ( _VirtualTable, [Avg] )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
9 | |
8 | |
5 | |
4 | |
3 |