Help me to fix my dax for calculating Total of hour

[sakuragihana]

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 ?

[tamerj1 · Accepted solution]

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
)

[tamerj1 · Accepted solution]

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
)

[sakuragihana]

Hi @tamerj1 ,

Thank you so much!

[sakuragihana]

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 ?

[tamerj1]

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

[sakuragihana]

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 ?

[tamerj1 · Accepted solution]

@sakuragihana 

[sakuragihana]

Hi @tamerj1 ,

Thank you a lot !