Measure multiple variable to return values

[rsanyoto]

Hi guys,

I have a challenge to return the right output based on the cost amount of a machine.

The current measures are :

Cost Amount MachineType = SUM(MachineTypeKosten[Cost Amount])

Machine worked time in hour  = SUM(Fact_MachineRegistratie[Duration]) / 60

Wrong = [Cost Amount MachineType] * [Machine worked time in hour]

The current output in a table looks like this:

 

  it seems that the multiply doesnt work on every row because  i expect on the first row 175 and not 350.

Any suggestion?

Many thanks

[amitchandak · Accepted solution]

@rsanyoto , You need to force a row context

like

sumx(summarize(Table, Table[StartingDatetime],"_1", [Cost Amount MachineType] * [Machine worked time in hour]),[_1])

not sure which table StartingDatetime belongs so used Table. You need to use one or more columns in summarize to group the data at the lowest level where you need to multiply these two