Need to capture the value selected in Slicer and use that value in other calcualtions

[kishu2012]

Hi All,

I would like to capture the value selected in the slicer and use that value in the further calculation. For example, if the user selects the year 2015 and a particular event in 2015, along with 2015 data, I also would like display 2014 data for that particular event.

Appreciate any inputs.

Thanks in advance!

Kishan

[v-caliao-msft]

Hi @kishu2012,

To achieve this requirement, you need to create a dynamic calculated column, the column value should changed along with the selected items in slicer. However, calculated column value is calculated when your power report initially run, and will not be re-calculated no matter which itmes you selected in slicer. So currently, I am afraid your requirement cannoe be achieved. Thank you for your understanding.

Regards,

Charlie Liao

[Sean]

@kishu2012

Previous Year Measure = CALCULATE ( SUM ( Table[Value] ), PREVIOUSYEAR ( CalendarTable[Date Column] ) )