measure for fuel consumption, two sources amount of liters, amount of kilometers

[carlosam]

I have to make a measure for fuel consumption, two sources amount of liters, amount of kilometers for each car; result: one column with two types of readings | l/km | km/l | my issue come with when filtered on slicer ( type of car) … I done with two different column | l/km | km/l |

Thanks

[amitchandak]

@carlosam , Can you share sample data and sample output in table format?

[carlosam]

Please your comments:

_kpi_Rendimientos RO_TR v04 =

VAR _Litros = SUM ( Integral_Mensual_Rend_Costo_stg[Combustible (lts)])

VAR _Recorridos = SUM (Integral_Mensual_Rend_Costo_stg[Total Horas/KM por periodo])

VAR _slicer = IF ( SELECTEDVALUE( Nombre_Comun_tbl[Unit]) = "k", 1, 0)

VAR _kmh = DIVIDE( _Recorridos, _Litros)

VAR _lth = DIVIDE( _Litros, _Recorridos)

RETURN

IF ( _slicer = 1, _kmh, _lth)

[v-kelly-msft]

Hi @carlosam ,

Is your issue solved now?If not,could you pls check my last reply?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[v-kelly-msft]

Hi  @carlosam ,

I have checked your request,your expression seems no problem,what is your expected output?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[carlosam]

My friend, with this info can you suggest solution.

[carlosam]

Date	Km	liter	Car
1-Aug	35	40	A
1-Aug		20	B
3-Aug	40	4	B
3-Aug		10	A
4-Aug	39	5	B
5-Aug	52	55	A

[carlosam]

Good mornig, thank you sr

Thanks