Help me to fix my dax for calculating Total of hour
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 ?
