cancel
Showing results for
Did you mean:
hamzahad91 Regular Visitor

Calculating SUM of TOPN rows ?

I have two columns

Done     |   Objectif

----------------------

2           |      8

4           |      6

6           |     14

null        |     12

null        |     11

null        |      9

..           |       ..

----------------------

I would that I print the Sum of 3 first rows beause I done  column we have juste 3 rows (  every mounth a value get added )

I think that I should use something lik SUM (table1[Objectif(TopN(COUNTROWS[Done])]) But It's not the right expression

1 ACCEPTED SOLUTION

Accepted Solutions Community Support Team

Re: Calculating SUM of TOPN rows ?

If your table is the one you posted here, maybe you could try this formula as a measure.

```Measure =
CALCULATE ( SUM ( Table1[Objectif] ), ISBLANK ( Table1[Done] ) = FALSE () )```

Or maybe you could add an index first, then it's easy to get the top three rows.

```Measure 2 =
CALCULATE ( SUM ( Table1[Objectif] ), 'Table1'[Index] <= 2 )``` Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
hamzahad91 Regular Visitor

Re: Calculating SUM of TOPN rows ?

Sorry I have made some mistakes I don't know how to mofify my post :

I would print the sum of 3 first rows beause in done column I have juste 3 rows (  every mounth a row will be added )

I think that I woulduse something like SUM (table1[Objectif(TopN(COUNTROWS[Done])]) But It's not the right expression

Here the result of my measure will be 28 ( 6+8+14 ). Community Support Team

Re: Calculating SUM of TOPN rows ?

If your table is the one you posted here, maybe you could try this formula as a measure.

```Measure =
CALCULATE ( SUM ( Table1[Objectif] ), ISBLANK ( Table1[Done] ) = FALSE () )```

Or maybe you could add an index first, then it's easy to get the top three rows.

```Measure 2 =
CALCULATE ( SUM ( Table1[Objectif] ), 'Table1'[Index] <= 2 )``` Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hamzahad91 Regular Visitor

Re: Calculating SUM of TOPN rows ?

`CALCULATE ( SUM ( Table1[Objectif] ), ISBLANK ( Table1[Done] ) = FALSE () )`

Can you explain me what does do the ISBLANK (Table1[Done] ) = FALSE() instruction ?

Highlighted Community Support Team