topic Re: Help me to fix my dax for calculating Total of hour in DAX Commands and Tips

Help me to fix my dax for calculating Total of hour

sakuragihana — Fri, 30 Jun 2023 10:02:02 GMT

Hello everyone, I have a power BI file with dax :

Standard Teaching Time =

VAR fulltypecode = SELECTEDVALUE('Contract'[FulltimeTypeCode])

VAR Dayteach = SELECTEDVALUE('Teacher Schedule'[DateNameSched])

VAR filer_standard = FILTER('StandardTime',

'StandardTime'[FulltimeTypeCode] = fulltypecode

&& Dayteach = 'StandardTime'[WeekDay])

VAR distribution = SUMMARIZE(filer_standard,'StandardTime'[Time Standard])

VAR Countdayofweek = 'Teacher Schedule'[DayOfWeekCount]

VAR Result = Countdayofweek * distribution

Return Result

The visual is :

The dax can not calculate the total of Standard Teaching Time

I make a power BI file with table data in this link:https://drive.google.com/file/d/1kc-GrVz2PvPxhUEBCq9yandeIvCUR_x4/view?usp=drive_link

Can everyone help me to fix this dax for calculating total ?

Re: Help me to fix my dax for calculating Total of hour

tamerj1 — Fri, 30 Jun 2023 11:21:01 GMT

Hi sakuragihana
Please refer to attched amended file with the solution

Standard Teaching Time = SUMX ( CROSSJOIN ( VALUES ( 'Contract'[FulltimeTypeCode] ), SUMMARIZE ( 'Teacher Schedule', 'Teacher Schedule'[Teacher Code], 'Teacher Schedule'[DateNameSched] ) ), VAR filer_standard = FILTER ( CALCULATETABLE ( 'StandardTime' ), 'StandardTime'[WeekDay] = 'Teacher Schedule'[DateNameSched] ) VAR distribution = SUMX ( filer_standard, 'StandardTime'[Time Standard] ) VAR Countdayofweek = [DayOfWeekCount] VAR Result = Countdayofweek * distribution RETURN Result )

Re: Help me to fix my dax for calculating Total of hour

sakuragihana — Mon, 03 Jul 2023 02:54:16 GMT

Hi tamerj1 ,

Thank you so much!

Re: Help me to fix my dax for calculating Total of hour

sakuragihana — Fri, 14 Jul 2023 04:23:48 GMT

Hi tamerj1 ,

If I want to calculate Standard Teaching Time for all of month .

Example : January 2023 have 31 days

Mon : 5 days

Tue : 5 days

Wed: 4 days

Thu : 4 days

Fri : 4 days

Sat: 4 days

Sun: 5 days

Can you help me to calculate standard teaching time for whole of months follow distribution of day ?

Re: Help me to fix my dax for calculating Total of hour

tamerj1 — Fri, 14 Jul 2023 06:32:00 GMT

sakuragihana
I did some modifications on the data model and the Standard Teaching Time measure. Please refer to attached for more details.

Re: Help me to fix my dax for calculating Total of hour

sakuragihana — Fri, 14 Jul 2023 07:02:31 GMT

Hi tamerj1 ,

I want to calculate Standard Teaching Time follow of DaysofWeekFullMonth by distribution . In this file the Standard Teaching Time was calculated by DayofWeekCount

Can you help me ?

Re: Help me to fix my dax for calculating Total of hour

tamerj1 — Fri, 14 Jul 2023 08:11:00 GMT

sakuragihana

Re: Help me to fix my dax for calculating Total of hour

sakuragihana — Tue, 18 Jul 2023 01:10:55 GMT

Hi tamerj1 ,

Thank you a lot !