Diffrent Calculation at RowLevel/TotalLevel

[myou]

Helloo ,

I have this table below, where the 3 columns are measures

Name	#workingdays	SumHrsMorningDelay	SumHrsEarlyLeave
Emp1	10	22	5
Emp2	20	2	10
Emp3	10
Total	40	24	15

I want to calculate AVG Morning Delay and Avg Early Leave

Name	#workingdays	SumHrsMorningDelay	SumHrsEarlyLeave	AVGMorningDelay	AVGEarlyLeave
Emp1	10	22	5	=22/10	=5/10
Emp2	20	2	15	=2/20	=15/20
Emp3	10
Total	40	24	15	=24/3Employees	15/3employees

I wrote this measure, its fine for row level , but the grand level is wrong

AVGMorningDelay(Hrs) =

if(ISFILTERED(Employee[exdyn_name]),

DIVIDE([MorningDelay],[#TotalWorkingDays],blank()), -- for row level

DIVIDE([MorningDelay],countrows(Employee),blank()) -- for grand level

)

[V-lianl-msft]

Hi @myou ,

If the problem persists,could you please share sample data or sample pbix?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Try Like

Avg Delay = DIVIDE([MorningDelay],[#TotalWorkingDays],0)

Over All Avg Delay = averagex (values(Employee[name]),[Avg Delay])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601