cancel
Showing results for
Did you mean:
Helper II

## TOTALYTD Total in Table

 DATE COUNTS COUNTS TYTD 2021-03 30 89 2021-02 28 59 2021-01 31 31 2020-12 26 323 2020-11 24 297 2020-10 42 273 2020-09 31 231 2020-08 22 200 2020-07 32 178 2020-06 31 146 2020-05 12 115 2020-04 21 103 2020-03 28 82 2020-02 23 54 2020-01 31 31 TOTAL 412 89

I need to total the TOTALYTD value over multiple years. The value is correct for each year but I need the table to return the total of each year and not just the current years YTD total. I would like it to return 412 instead of 89 ( 89 + 323).

1 ACCEPTED SOLUTION
Super User

Hi, @NickTT

The sample pbix file's link is down below.

Counts TYTD FIX =
SUMX( VALUES('Date'[Year]), TOTALYTD([Counts Total], 'Date'[Date]))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

4 REPLIES 4
Helper II

That works correctly in a Matrix but what about Table? In a Table it's returning the same row values as COUNTS.

Super User

Hi, @NickTT

The sample pbix file's link is down below.

Counts TYTD FIX =
SUMX( VALUES('Date'[Year]), TOTALYTD([Counts Total], 'Date'[Date]))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Helper II

That did the trick!

Super User

@NickTT , use isinscope or isfiltered and change measure to simple sum

if(isinscope(Date[Date]), [COUNTS TYTD], [COUNTS])

or

if(isfiltered(Date[Date]), [COUNTS TYTD], [COUNTS])

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors