CALCULATE filtered by LASTDATE

[John_Silva642]

Hello,

I'm having a problem using the measure CALCULATE filtering by a text value, and the LASTDATE.
Can someone help me, please?

This is the expression:

VAR DATAMAX =

LASTDATE('F&A'[Data])

VAR RESULT =

CALCULATE(

SUM('F&A'[Valor]),

'F&A'[Informações] = "Iniciativas Entregues",

DATAMAX

)

RETURN

RESULT

TableMeasure

The result should be 3, but the measure brings the soma of all values (2+3=5).
How can I fix this problem?

[AlexisOlson · Accepted solution]

This is likely because DATAMAX isn't "Iniciativas Entregues".

If you want the last date for that specific text filter, then you'll need to modify your measure.

VAR DATAMAX =
    CALCULATE (
        LASTDATE ( 'F&A'[Data] ),
        'F&A'[Informações] = "Iniciativas Entregues"
    )
VAR RESULT =
    CALCULATE (
        SUM ( 'F&A'[Valor] ),
        'F&A'[Informações] = "Iniciativas Entregues",
        'F&A'[Data] = DATAMAX
    )
RETURN
    RESULT

[AlexisOlson]

You're almost there.

Try this:

VAR DATAMAX = LASTDATE ( 'F&A'[Data] )
VAR RESULT =
    CALCULATE (
        SUM ( 'F&A'[Valor] ),
        'F&A'[Informações] = "Iniciativas Entregues",
        'F&A'[Data] = DATAMAX
    )
RETURN
    RESULT

[John_Silva642]

It's returning a blank value now.

Attempt1Attempt Measure

[AlexisOlson · Accepted solution]

This is likely because DATAMAX isn't "Iniciativas Entregues".

If you want the last date for that specific text filter, then you'll need to modify your measure.

VAR DATAMAX =
    CALCULATE (
        LASTDATE ( 'F&A'[Data] ),
        'F&A'[Informações] = "Iniciativas Entregues"
    )
VAR RESULT =
    CALCULATE (
        SUM ( 'F&A'[Valor] ),
        'F&A'[Informações] = "Iniciativas Entregues",
        'F&A'[Data] = DATAMAX
    )
RETURN
    RESULT

[John_Silva642 · Accepted solution]

Thanks, @AlexisOlson!

Problem solved!

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[John_Silva642]

Thanks, @Ashish_Mathur!