cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baw556
Frequent Visitor

Summing Column on Multiple Category

Hello All,

 

I have this table

engergyCapture.PNG

 

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,

 

1 ACCEPTED SOLUTION
AlB
Super User
Super User

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  Datanaut

View solution in original post

3 REPLIES 3
AlB
Super User
Super User

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  Datanaut

baw556
Frequent Visitor

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

baw556
Frequent Visitor

 

The desired result from below should be Adjusted_consumption approx. 203. However, using the formula above, I'm still getting 55.

 

Thanks in advance.

 

engergyCapture2.PNG

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors