Here is my Measure. I cannot figure out what I am doing wrong (Newbie). I get the above Error and I searched "the" google and was having trouble finding any datetime SUMX examples. Hoping you more experienced people can help.

SRHours =

IF ( ( ( (DATEDIFF (SUMX('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened] ),TODAY (),DAY ) ) - (DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),TODAY (),DAY ) )) = 1 ) && SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ) >= SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened].[Date] + TIMEVALUE ( "08:00:00" ) ) && SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ) <= SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened].[Date] + TIMEVALUE ( "18:00:00" ) ), ( ( (DATEDIFF (SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ),TODAY (),DAY ) ) - DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),TODAY (),DAY ) ) * 10 ) + (DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date].[Date] + TIMEVALUE ( "08:00:00" ) ),SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),MINUTE ) ), IF ( ( ( (DATEDIFF (SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ),TODAY (),DAY ) ) - DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),TODAY (),DAY ) ) > 1 ) && SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ) >= SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened].[Date] + TIMEVALUE ( "08:00:00" ) ) && SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ) <= SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened].[Date] + TIMEVALUE ( "18:00:00" ) && SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ) >= SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date].[Date] + TIMEVALUE ( "08:00:00" ) ) && SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ) <= SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened].[Date] + TIMEVALUE ( "18:00:00" ) ) ), ( (DATEDIFF (SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ),TODAY (),DAY ) - DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),TODAY (),DAY ) * 10 ) + (DATEDIFF (SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ),SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[Date/Time Opened].[Date] + TIMEVALUE ( "18:00:00" ) ),MINUTE ) + (DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date].[Date] + TIMEVALUE ( "08:00:00" ) ),SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),MINUTE ) ) ) ), ( (DATEDIFF (SUMX ( 'SRInsights-SupportCases', 'SRInsights-SupportCases'[Date/Time Opened] ),TODAY (),DAY ) - DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),TODAY (),DAY ) * 10)

+ (DATEDIFF (SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date].[Date] + TIMEVALUE ( "08:00:00" ) ),SUMX ('SRInsights-SupportCases','SRInsights-SupportCases'[First Response Date] ),MINUTE) ) ) ))

I know this is complex but I kept running into Cyclic Redundancy issues with combining 3 measures. Again, newbie issues I'm sure, but I am running out of time to get this figured out.

Thanks in advance for trhe hlep.

Kevin

Forum Discussion

Boolean Aggregate Functions?

CONTAINS function - Boolean error

Convert boolean value using Value function

boolean on other boolean

FILTER vs Boolean Expression