Multiplying interactive slicers with columns.

[KasRotodyne]

Dear,

I am looking to develop a power bi for our sales department for them to show the TCO for end customers. The benefit of buying a higher efficiency class.

Power*Company cycle ...hoursperday*day in a year......* Energiecost.....(money/kWh)..... * difference in efficiency %               |vs|

Cost IE4-IE3.

The problem is the energycosts per hours in a year.

Power and efficiency are in a column.

Hours per day, days in a year and energy cost are interactive slicers. 

I starting to believe this is not possible.

Any tips? Im starting to lose hope.

[tamerj1]

Hi @KasRotodyne 

calculated columns do not interact with the filter context. This has to be a measure. 

[KasRotodyne]

And woulkd you have me do? 

I was looking to make a visual interactive to show the increase and decrease in savings at different times.

is this possible with measures? i dont think so...

[tamerj1]

@KasRotodyne 

Would you please copy/paste the dax code that you have tried and provide some sample of the source data