Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi All,
Currently I have the following calculation in a table visual
@Mburman-07 , First create a measure for Capacity
Capacity__ = SUM(Sites[Capacity]) * 1000
Then create the measure for CF
CF =
DIVIDE(
SUM(MeterVolume[ENERGY_GENERATION_VOLUME]),
[Capacity__] * SUM(Calendar[Days in Month]) * 24
)
This measure can now be used in your bar chart in Power BI.
Proud to be a Super User! |
|
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
30 |