Forum Discussion

jeffr6596's avatar
jeffr6596
Frequent Visitor
1 year ago
Solved

Multi step measure

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 ...
  • johnt75's avatar
    johnt75
    1 year ago

    You can create a measure like

    Contacts made on time =
CALCULATE (
    SUM ( 'Table'[Number of contacts made] ),
    'Table'[On time] = "on time"
)
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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"
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

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"
)