How to display the last value of a measure based on a condition

[Anonymous]

Hello everyone,

I am pretty new to Power BI and sorry if my question is so simple. I have a table like this:

	Calculated Column	Calculated Column	Calculated Column	Measure	Column	Measure	Measure
Fecha	Solicitado	Cubierto	Pendiente	Acumulado	Teorico	Coberturado	% coberturado
1/1/2022	1	1	0	0	2	2	100%
1/1/2022	1	1	0	0	2	2	100%
1/1/2022	2	1	1	1	2	1	50%
2/2/2022	1	2	-1	0	2	2	100%
2/2/2022	1	2	-1	-1	2	3	150%

Formulas on excel are:

Pendiente: Solicitado - Coberturado 

Coberturado: Teórico - Acumulado 

% Coberturado: Coberturado /Teórico

My expected table in a dashboard is this:

	Calculated Column	Calculated Column	Calculated Column	Measure	Column	Measure	Measure
Fecha	Solicitado	Cubierto	Pendiente	Acumulado	Teorico	Coberturado	% coberturado
1/1/2022	4	3	1	1	6	5	83%
2/1/2022	2	4	-2	-1	4	5	125%

I would like to show the last value of the column "%Coberturado" based of the column Fecha in a card visual which is 125% but since it's a measure i can't. 

Thanks!!!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try:

Coberturado 2 = SUMX('Table',[Coberturado])

% Coberturado 2 = [Coberturado 2]/SUM('Table'[Teorico])

Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tom480]

Hi there!

Let me know if this works for you.  Instead of a measure, make it a calculated column.  Tom

CalcCol1 = DIVIDE(Table2[Coberturado], Table2[Teorico])

Card1 =

CALCULATE (

AVERAGE(Table2[CalcCol1]),

FILTER ( VALUES ( Table2[Fecha] ), [Fecha] = MAX ( Table2[Fecha] ) )

)