Forum Discussion
Solved
DAX Query
I have the DAX below to create a measure that - find those calls where the Planned Duration = 15 mins and the Delivered Duration is between 0 and 17 mins, and then total the Test Cost and multip...
Let me assume that you are working at row level of source data table. In this case please try
Test New =
SUMX (
FILTER (
'Procurement_Main_Data',
'Procurement_Main_Data'[Planned Duration] = TIMEVALUE ( "00:15" )
&& 'Procurement_Main_Data'[Delivered Duration] >= TIMEVALUE ( "00:00" )
&& 'Procurement_Main_Data'[Planned Duration] <= TIMEVALUE ( "00:17" )
),
'Procurement_Main_Data'[Test Cost] * 'Procurement_Main_Data'[Delivered Duration Decimal]
)
