Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
I have issues with two of my current formulas:
1) Co2 from electricity = Electricity (mwh) x market based factor
The market factor is based on the country, therefore the value different per plant. For example, for Q1 it should be 891 x 0.4 = 356.4 , but instead it is taking the sum of 0.4 (1.19) and multiplying (to then equal 1058.51), when I need the market factor to remain a fixed value when multiplying.
Currently I have the following measures:
2) Co2 from combustion = Total combustion x Factor Natural Gas
The same issue here, except the factor needs to always remain the same. Should be 811 x 0.2 = 162.2 (but instead the answer is coming out as 491.22).
Currently I have the following measure:
I would appreciate any help or advice, thanks in advance!
Solved! Go to Solution.
@Anonymous Not sure I completely understand this. It looks like you have a table visual with the correct numbers in it. Where do those come from? Can you not just use those in your formula? If the second and third columns are columns, just use the same aggregation for those as in the table visual. For example, if they are default Sum aggregation, use SUM([Market based FACTOR]) or if they are Max, use MAX([Market based FACTOR])
@Greg_Deckler thanks so much, your advice worked! I needed to use "max" in place of "sum" for the factors and they reamined at a fixed value.
@Anonymous Not sure I completely understand this. It looks like you have a table visual with the correct numbers in it. Where do those come from? Can you not just use those in your formula? If the second and third columns are columns, just use the same aggregation for those as in the table visual. For example, if they are default Sum aggregation, use SUM([Market based FACTOR]) or if they are Max, use MAX([Market based FACTOR])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
107 | |
89 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |