Multi step measure

Question

I am attempting to write a measure and would appreciate assistance.

I have a table with columns for

Submitted Date

Due Date

I have added a column with the measure written to determine if the items were submitted on time.

ON TIME = IF(DATEVALUE([Date Submitted]) <= [Due Date], "On Time", "Late")

I also have columns for

Number of Contacts Required

Number of Contacts Made

I am attempting to write a measure which will calculate the sum of Number of Contacts Made only if the item was on time.

Is there a way to do this?

Thanks

johnt75 · Accepted Answer

You can create a measure like
Contacts made on time =
CALCULATE (
    SUM ( 'Table'[Number of contacts made] ),
    'Table'[On time] = "on time"
)

Forum Discussion