DAX Query

[spandy34]

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 multiply by Delivered Duration Decimal - can you see anything wrong with below?  Its doing the first part just not multiplying the answer by the Delivered Duration Decimal

"DAX - 

Test New = CALCULATE(SUM('Procurement_Main_Data'[Test Cost]),'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'[Delivered Duration Decimal]))   "

 

@amitchandak, @tamerj1 , @danextian @goncalogeraldes 

[tamerj1 · Accepted solution]

@spandy34 

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

[spandy34]

Thats worked !! Thank you so much your a star.

[spandy34]

Ive took a braket out and got rid of the error but the Test New still doesnt say 0.56

[tamerj1]

Hi @spandy34 

please try

Test New =
CALCULATE (
SUM ( 'Procurement_Main_Data'[Test Cost] ),
'Procurement_Main_Data'[Planned Duration] = TIMEVALUE ( "00:15" )
&& 'Procurement_Main_Data'[Delivered Duration] >= TIMEVALUE ( "00:00" )
&& VALUE ( 'Procurement_Main_Data'[Planned Duration] )
<= VALUE ( TIMEVALUE ( "00:17" ) ) * ( 'Procurement_Main_Data'[Delivered Duration Decimal] )
)

[spandy34]

Thank you @tamerj1 for responding.

I have tried the DAX and I am getting 0.28 and I should be getting 0.56 - see below

[tamerj1]

@spandy34 

If you place the measure in the table, does it give the same value?

[spandy34]

Yes -

[tamerj1]

@spandy34 

Perhaps you mean

Test New =
CALCULATE (
SUM ( 'Procurement_Main_Data'[Test Cost] ),
'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'[Delivered Duration Decimal]

?

[spandy34]

Ive tried ? and ) at the end of the DAX and get these errors

[tamerj1]

@spandy34 

Lol 

please delete the question mark. 

[spandy34]

I get this error now

[tamerj1]

@spandy34 

Ok so this a summarized column not a measure. Is it summarized by sum?