Calculate total on each row based on year

[Isildur13]

Hi Community

I need help with calculating the total amount for the whole year and display it on the rows in my table. I have no date table since the data only includes a year column.

I have tried to do the following in DAX:

$ Total Amount Year =

    CALCULATE (

        [$ Amount],

        FILTER (

            ALLSELECTED(  'Periode'[Year]),

            [Year] = Periode[Year]

        )

    )

But it still filters out the amount on each rows instead of showing the total for the year. Is it possible to do without a date table? 

[Daniel29195]

@Isildur13 

$ Total Amount Year =

    CALCULATE (

        [$ Amount],

        allexcept( table_name ,   Periode[Year] ) 

    )

or : 

$ Total Amount Year =

    CALCULATE (

        [$ Amount],

        all( table_name), 

values ( period[year])  

    )

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

[Isildur13]

Hi @Daniel29195 

It worked! 

I went with the second solution and added one more values field.

I have one more question:

Is it possible to add another measure where the totals just calculated is shown like a last year? So the total amount year for category A 2020 367.75 would be displayed on category A 2021 instead?

[Daniel29195 · Accepted solution]

@Isildur13 

try this : 

$ Total Amount last Year =

var  last_year =  max( period[year])   - 1 

    CALCULATE (

        [$ Amount],

        all( table_name), 

period([year]) = last_year

    )

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

[danextian]

Hi @Isildur13 ,

This should be what you're looking for. Feel free to provide more details about your specific scenario if you desire a different outcome.