[DAX] Get previous row value of a dynamic measure

[Anonymous]

Hi!

I'm trying to get the previous row value of a dynamic measure but all the queries I try so far didn't work.

Blank measure

Dynamic measure

DynamicMeasure = IF(SELECTEDVALUE( MainMeasureSlicer[Display As])="Revenue"|
  SUM(Pipeline[TotalValue])|
  DISTINCTCOUNT(VwFaturamento[Id])
 )

Previous Measure

Previous DynamicMeasure = 
VAR prevrank =
    CALCULATE (
        MAX([DynamicMeasure])|
        FILTER ( Bridge| Bridge[Rank] < EARLIER(Bridge[Rank]|1) )
    )
RETURN
    IF (ISBLANK (prevrank)|BLANK() | prevrank )

Error message

Error message

Goal

What I want

Can anyone help me, please?

Any help would be very appreciated,

Thanks! 

[Anonymous]

I'm trying to get the previous row value of a dynamic measure but all the queries I try so far didn't work.

Blank measure

Dynamic measure

DynamicMeasure = IF(SELECTEDVALUE( MainMeasureSlicer[Display As])="Revenue"|
  SUM(Pipeline[TotalValue])|
  DISTINCTCOUNT(VwFaturamento[Id])
 )

Previous Measure

Previous DynamicMeasure = 
VAR prevrank =
    CALCULATE (
        MAX([DynamicMeasure])|
        FILTER ( Bridge| Bridge[Rank] < EARLIER(Bridge[Rank]|1) )
    )
RETURN
    IF (ISBLANK (prevrank)|BLANK() | prevrank )

Error message

Error message

Goal

What I want

Can anyone help me, please?

Any help would be very appreciated,

Thanks! 

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank