ISFILTERED doubt

[sadath]

Hi,

I have a YEAR slicer in my Power BI and following DAX formula

IsFilter=isfiltered(SALESDATA[YEAR])

=if([IsFIlter],sum(SALESDATA[SALES]))

the YEAR slicer having contents like 2015,2016,2017

can i change the formula into
if I select 2015 in YEAR slicer show the result of =CALUCLATE(sum(SALESDATA[SALES]),SALESDATA[YEAR]="2015")
if i select 2016 in YEAR slicer show the result of =CALUCLATE(sum(SALESDATA[SALES]),SALESDATA[YEAR]="2016") and
if i select 2017 in YEAR slicer show the result of =CALUCLATE(sum(SALESDATA[SALES]),SALESDATA[YEAR]="2017")

 

[Matt Allington]

What I think you are describing is the exact standard inbuilt behaviour of power pivot. If you put a slicer on salesdata[year] and write a measure sum(salesdata[sales]) added to your visual, then a click on the slicer will give the sales for that year. That is what it is designed to do out of the box. You don't need isfiltered and calculate.

am I misunderstanding something?