[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.

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

Goal

Can anyone help me, please?

Any help would be very appreciated,

Thanks! 

[v-danhe-msft]

Hi @Anonymous ,

Could you please post your sample file to have a test if possible?

Regards,

Daniel He