Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
apagan
Helper I
Helper I

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!

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

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

View solution in original post

3 REPLIES 3
v-ljerr-msft
Employee
Employee

Hi @apagan,

 

In addition, the formula below should also work.Smiley Happy

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

 

Regards

Sean
Community Champion
Community Champion

@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
Resolver III
Resolver III

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

))

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.