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!

FarhanAhmed1984's avatar
FarhanAhmed1984
Resolver III
9 years ago

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

))