Slicer and measures

[marcos_osorio]

HI, I'm really new in PowerBI, i want to know if its possible this:

I have a table with several columns, on of the for example is Qtty. 

I like to display something like:

This year Qtty|Diff vs Last Year Qtty filtered by some filed type.

I already made a measure and work as a total, ex:

LY Qtty = CALCULATE(SUM('BI Analysis'[Qtty]),YEAR('BI Analysis'[DATE RECORD])=2017,'Type of Data'[TYPE] = "Result" )

TY Qtty = CALCULATE(SUM('BI Analysis'[Qtty]),YEAR('BI Analysis'[DATE RECORD])>2017,'Type of Data'[TYPE] = "Shipment Result" )

Then I use TY minus LY. 

This wors fine, but I want to insert a slicer based on [DATE RECORD] and to respond in base of that.

Now if i do it, the TY works fine, but the LY show now data when selecting for example the range: [05-01-2018/12-31-2018]

Is there a  way to do it?

Thanks, 

[v-danhe-msft]

Hi @marcos_osorio ,

Could you please offer your sample data and post your desired result if possible?

Regards,

Daniel He

[marcos_osorio]

Sorry for the delay, I could manage to do it.

Thank you very much.