I have this table
I already have a Tabular Model created to be used in Power BI. I was wondering how to calculated the adjusted consumption using DAX based on its formula shown below the table?
Go to Solution.
Do you want it across all asset types and classes? If so, place tis measure in a card visual:
VAR Constant_ = 4.3456
CALCULATE ( SUM ( Table1[Consumption] ), Table1[Fuel] = "Electricity" )
+ CALCULATE ( SUM ( Table1[Consumption] ), Table1[Fuel] = "Gas" ) * Constant_
Please mark the question solved when done and consider giving kudos if posts are helpful.
View solution in original post
Thanks AIB for your response and I apologize for late reply.
Yes, I wanted to aggregate accross asset type and class.
When I appplied the formula, it only aggregates the valus for Electricity and doesn't include the secod part of the formula (Gas cons. * constant)
The desired result from below should be Adjusted_consumption approx. 203. However, using the formula above, I'm still getting 55.
Thanks in advance.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.