DAX to implement the cumulative order count RRS feed

  • Question

  • Hello Friends,

    I am using the countrows to calculate the "order count" based on the order table. And I use this calculation(=CALCULATE(COUNTROWS(FactOrder), DATEADD(DimDate[CalendarDate],-1,YEAR))) to get the "order#".

    As the calculated column can not be dragged into "Value" zone twice, then I cannot use the new feature of "show values as..." then I have to turn to DAX again to figure hwo to implement the "cumlative order count previous year".

    Any Idea about this?


    Wednesday, April 4, 2012 10:09 PM


  • Solved and for sharing

    Repeat the DAX function as the second measure then drag into "value" zone. using "Show as running total"


    • Marked as answer by Derek Dai Wednesday, April 4, 2012 10:35 PM
    Wednesday, April 4, 2012 10:35 PM