cancel
Showing results for
Did you mean:
Post Prodigy

cumulate over year

hi all,

i use following formula to cumulate over years:

DB_cumulate_year = CALCULATE(SUM(Table1[DB]), FILTER(ALL(Table1), Table1[Year] <= MAX(Table1[Year])))

The problem is that i also use a Table2 which is connected with Table1. On my canvas I have three slicer with columns from Table2. That dont work because I use ALL(Table1).

How could I avoid ALL(Table1) and still cumulate over years?
1 ACCEPTED SOLUTION
Post Prodigy

Thank you! But i found a third way... just use ALLEXEPT with the exeption of the three slicer from Table2. Seems to work 🙂

1 - Many is right but from Table 2 to Table 1.

2 REPLIES 2
Post Prodigy

Thank you! But i found a third way... just use ALLEXEPT with the exeption of the three slicer from Table2. Seems to work 🙂

1 - Many is right but from Table 2 to Table 1.

Super User

@Pikachu-Power , if that 1 - Many from Table 1 to table 2 and you are using year from table 1 it should work.

Else create a common year table and use that (join with both tables)

CALCULATE(SUM(Table1[DB]), FILTER(ALL(Year), Year[Year] <= MAX(Year[Year])))

CALCULATE(SUM(Table2[DB2]), FILTER(ALL(Year), Year[Year] <= MAX(Year[Year])))

Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Announcements