Calculating SUM of TOPN rows ?

[hamzahad91]

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

[hamzahad91]

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 ).

[v-jiascu-msft · Accepted solution]

Hi @hamzahad91,

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

[hamzahad91]

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

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

[v-jiascu-msft]

Hi @hamzahad91,

I have seen there were NULL values. Null is blank in Power BI unless you use it as a text. ISBLANK (Table1[Done] ) is going to check if "Table1[Done]" is blank. The return value of ISBLANK() is a Boolean, which is True or False. So "ISBLANK (Table1[Done] ) = FALSE()" return the first three rows, which isn't blank.

Best Regards!

Dale