Forum Discussion

ozgurozturk98's avatar
ozgurozturk98
Frequent Visitor
7 years ago
Solved

Counting rows

Hi all,

 

I'm trying to count the total rows where SOLLAST is less than or equal to the Date. I want something like this.

 

Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    ozgurozturk98 Please try this..

     

    TotalRows = CALCULATE(COUNT(TestCount[SOLLAST]),
                      FILTER(ALL(TestCount),TestCount[SOLLAST]=EARLIER(TestCount[Date])))

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    ozgurozturk98,

    Could you please describe more details about the logic you use to calculate the above expected result?

    I am not sure about how you get 2,5,1 based on the sample data.


    Regards,
    Lydia

    • ozgurozturk98's avatar
      ozgurozturk98
      Frequent Visitor
      7 years ago

      Anonymous

       

      Well you can consider the left column (date) as the current date. The SOLLAST describes the total orders.

       

      E.G.

       

      On the date 10-6-2018 there are two times a solllast with the same date. So ''Date" has a total row of 2.

      • PattemManohar's avatar
        PattemManohar
        Community Champion
        7 years ago

        ozgurozturk98 Please try this..

         

        TotalRows = CALCULATE(COUNT(TestCount[SOLLAST]),
                      FILTER(ALL(TestCount),TestCount[SOLLAST]=EARLIER(TestCount[Date])))