Forum Discussion
Recreating calculation as a measure
Hi All,
Currently I have the following calculation in a table visual
CF = [Sum of ENERGY_GENERATION_VOLUME]/([Capacity_]*[Days in Month]*24)
The items in the visual are:
Days In month which is a column in my calendar table
Energy Generation Volume which is a column in the Meter Volume Table
Capacity__ which is a measure consisting of the Capcaity column in my Sites Table * 1000
I want to try and recreate this calculation as a measure so that I can use it in a bar chart like the below.
The items in the visual are:
Days In month which is a column in my calendar table
Energy Generation Volume which is a column in the Meter Volume Table
Capacity__ which is a measure consisting of the Capcaity column in my Sites Table * 1000
I want to try and recreate this calculation as a measure so that I can use it in a bar chart like the below.
1 Reply
Anonymous , 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.
