topic Multiplying interactive slicers with columns. in DAX Commands and Tips

Multiplying interactive slicers with columns.

KasRotodyne — Wed, 19 Apr 2023 13:28:20 GMT

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.

Re: Multiplying interactive slicers with columns.

tamerj1 — Wed, 19 Apr 2023 13:52:25 GMT

Hi KasRotodyne

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

Re: Multiplying interactive slicers with columns.

KasRotodyne — Wed, 19 Apr 2023 14:30:48 GMT

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...

Re: Multiplying interactive slicers with columns.

tamerj1 — Wed, 19 Apr 2023 15:34:59 GMT

KasRotodyne

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