Dividing 2 results Using DAX

[apagan]

I am attempting to divide the results of two calculations against each other, but I am getting the error, "The end of the input was reached". 

Here is the formula that I am using, can you tell me what it is that I am doing wrong?

CALCULATE( 

DIVIDE(  AVERAGE(table[Liter]), FILTER(table, [Fuel Type]="Premium"),FILTER(table,[Result]="Fail")),

(  AVERAGE(table[concentration]), FILTER(table, [Fuel Type]="Premium"),FILTER(table,[Result]="Fail") 

)

Thanks, in advance!

[v-ljerr-msft]

Hi @apagan,

In addition, the formula below should also work.

Measure =
CALCULATE (
    DIVIDE ( AVERAGE ( table[Liter] ), AVERAGE ( table[concentration] ), 0 ),
    FILTER ( table, table[Fuel Type] = "Premium" && table[Result] = "Fail" )
)

Regards

[Sean · Accepted solution]

@apagan

I believe this is what you are trying to do

Measure =
DIVIDE (
    CALCULATE (
        AVERAGE ( table[Liter] ),
        FILTER ( table, table[Fuel Type] = "Premium" && table[Result] = "Fail" )
    ),
    CALCULATE (
        AVERAGE ( table[concentration] ),
        FILTER ( table, table[Fuel Type] = "Premium" && table[Result] = "Fail" )
    ),
    0
)

Good Luck!

[FarhanAhmed1984]

Please try following

CALCULATE(

DIVIDE(  CALCULATE(AVERAGE(table[Liter]), FILTER(table, [Fuel Type]="Premium"),FILTER(table,[Result]="Fail")),

CALCULATE( AVERAGE(table[concentration]), FILTER(table, [Fuel Type]="Premium"),FILTER(table,[Result]="Fail"))

))