Hi! As a total beginner to Power BI my problem is the following:
In my query I have several columns with revenues, costs and amounts for each month over several years and 2 scenarios (plan and forecast):
- revenue electricity (€)
- amount of electricity (MWh)
- cost gas input (€)
- amount of gas input (MWh)
- ...
I added columns to calculate specific performance indicators that show the revenue/cost per amount, e.g. revenue electricity (€/MWh), cost gas input (€/MWh). Then I unpivoted all the revenue, cost and performance indicator columns and now have one column with all the indicators (calculated and base indicators).
Now I want to build a table visual which shows me the calculated performance indicators in the rows and the value for plan and forecast in the columns:
| | plan | FC |
| revenue electricity (€/MWh) | 12,34 | 14,56 |
| cost gas (€/MWh) | 5,67 | 3,34 |
I used two measures:
= calculate (average(indicators[value], indicators[scenario="plan")
= calculate (average(indicators[value], indicators[scenario="fc")
This works for one months, but I want the calculation to be for one year, e.g. choose 2020 or 2021 from a slicer above and the table should show total revenue electricity and total cost gas divided by the total electricity/gas amount for that year. As it is the measure returns the average of the 12 values for one year, which ist not the same as the total values divided by each other. How do I do this? I can create specific measures for each of the 4 performance indicators in the table above. But then I can't show them in one table...
I hope I have made myself clear enough.
