cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hamzahad91 Regular Visitor
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
Community Support Team

Re: Calculating SUM of TOPN rows ?

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 )

Calculating SUM of TOPN rows.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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
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
Community Support Team

Re: Calculating SUM of TOPN rows ?

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 )

Calculating SUM of TOPN rows.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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
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
Community Support Team

Re: Calculating SUM of TOPN rows ?

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

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.