Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Hi @KasRotodyne
calculated columns do not interact with the filter context. This has to be a measure.
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...
Would you please copy/paste the dax code that you have tried and provide some sample of the source data
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |