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!

Sean's avatar
Sean
Community Champion
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!