Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
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?
Thanks,
Solved! Go to Solution.
Hi @baw556
Do you want it across all asset types and classes? If so, place tis measure in a card visual:
Measure = VAR Constant_ = 4.3456 RETURN 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.
Cheers
Hi @baw556
Do you want it across all asset types and classes? If so, place tis measure in a card visual:
Measure = VAR Constant_ = 4.3456 RETURN 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.
Cheers
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)
Any thoughts?
Thanks,
Baw556
The desired result from below should be Adjusted_consumption approx. 203. However, using the formula above, I'm still getting 55.
Thanks in advance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |