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

Well, in that case, you create a table variable using SUMMARIZE or GROUPBY that is essentially the same as your visualization. You use ADDCOLUMNS to add your measure as a column. You then use ADDCOLUMNS again to add your cumulative measure as a column. You then can filter down to the correct row in the table.

 

The technique is essentially laid out here:  https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

 

 

 

  • phoisan's avatar
    phoisan
    Helper I
    6 years ago

    I'm not really understand how to do it. I'm new to the Power BI.

     

    I'll try to understand the articles you shared .

     

    Thanks

    • 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!