topic Re: Multi step measure in DAX Commands and Tips

Multi step measure

jeffr6596 — Thu, 16 Jan 2025 14:52:29 GMT

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 — Thu, 16 Jan 2025 15:13:43 GMT

You can create a measure like

Contacts made on time = CALCULATE ( SUM ( 'Table'[Number of contacts made] ), 'Table'[On time] = "on time" )

bhanu_gautam — Thu, 16 Jan 2025 15:14:12 GMT

jeffr6596 Yes, you can achieve this by creating a measure that sums the "Number of Contacts Made" only for the items that were submitted on time

DAX
SumOfContactsMadeOnTime =
CALCULATE(
SUM('YourTable'[Number of Contacts Made]),
'YourTable'[ON TIME] = "On Time"
)