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 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!

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!

3 Replies

  • 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!

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

    ))

  • 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