Forum Discussion

phoisan's avatar
phoisan
Helper I
6 years ago

Get Measure value based on condition DAX

Hi,   I'm facing problem to calculate current measure value + Previous row measure value   Seq, Time, DP are source data. Airflow is calculated column = IF(DP< 0.1,0,EXP((LN(DP /4.322)/1.2791)))...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

phoisan  I really felt more like going to bed rather than downloading another PBIX tonight, but here you go, updated PBIX is attached below the sig.

 

Energy Cumulative = 
    VAR __Seq = MAX('Test'[Seq])
    VAR __Table = 
        SUMMARIZE(
            FILTER(ALL('Test'),[Seq]<=__Seq),
            [Seq],
            "Energy",[Energy]
        )
RETURN
    SUMX(__Table,[Energy])

 

 

phoisan's avatar
phoisan
Helper I
6 years ago

This is brilliant....fixed my problem. thanks 
This issue had been stuck me for past three days!