Forum Discussion

apagan's avatar
apagan
Helper I
9 years ago
Solved

Dividing 2 results Using DAX

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...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    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!

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi apagan,

 

In addition, the formula below should also work.:smileyhappy:

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

 

Regards