DAX Code Functions while using slicer

[Anonymous]

Hello! I have been struggling to find an efficient way to filter my data in a card using measures (and DAX). I am currently pretty new to the language so I am not sure what really is capable or not. With saying that I will explain the issue I am having and am open to any other comments and or critiscims. 

I currently want to display a card value of a sum of values dependendant on the year.  For example my data table is setup similar to that below. 

Year      Building    Total MTeCO2

2015      AAA          xx

2015      AA            xx

2016      AAAA       xxx 

2016      AAA         xx

2016      AA           xxxx 

2017      AAA         x 

2017      AA            xx

Ideally I would not like to create a custom column or table. I was hoping to be ableto use a a slicer to filter the table by years then be able to sum the values for that specific year as needed. The DAX code I have been using reads: 

"Measure = CALCULATE(sum(Building_Reports2[Total MTeCO2]),Building_Reports2[Year])"

Unfortunately this code does not find the sum of the values for the specific year that is filtered but rather finds the sume of the entire unfiltered table. 

Any tips, comments  or suggestions are welcomed! Thanks!

Austin I (: 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

How about this measure

Measure =
CALCULATE (
    SUM ( Building_Reports2[Total MTeCO2] ),
    ALLSELECTED ( Building_Reports2[Year] )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.