Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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!
Hi @apagan,
In addition, the formula below should also work.
Measure = CALCULATE ( DIVIDE ( AVERAGE ( table[Liter] ), AVERAGE ( table[concentration] ), 0 ), FILTER ( table, table[Fuel Type] = "Premium" && table[Result] = "Fail" ) )
Regards
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!
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"))
))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |