I require some assistance with developing a DAX measure for the following scenario:
I want determine what % saving multiple projects have on a sites total energy consumption.
Each projects has a savings %, but as you iterate through each project, the value of the energy consumed is now less
(i.e.: project 1 saves 10 %, and project 2 saves a further 5%, however project 2’s percentage saving of 5 % is on 90% (100% - Project 1’s savings %).
I believe the measure is something like:
Total Energy x (1 - (1 - Project 1’s % ) x (1 - Project 2’s % )…) etc.
This measure will need to be dynamic to count the total projects per site.
Any help would be greatly appreciated