Forum Discussion
Multiplying interactive slicers with columns.
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.
3 Replies
- tamerj1Community Champion
Hi KasRotodyne
calculated columns do not interact with the filter context. This has to be a measure.
- KasRotodyneFrequent Visitor
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...
- tamerj1Community Champion
Would you please copy/paste the dax code that you have tried and provide some sample of the source data