topic Re: Summing Column on Multiple Category in DAX Commands and Tips

Summing Column on Multiple Category

baw556 — Sat, 12 Oct 2019 23:00:51 GMT

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,

Re: Summing Column on Multiple Category

AlB — Sun, 13 Oct 2019 09:20:08 GMT

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

Re: Summing Column on Multiple Category

baw556 — Tue, 15 Oct 2019 16:05:36 GMT

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

Re: Summing Column on Multiple Category

baw556 — Tue, 15 Oct 2019 16:08:09 GMT

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

Thanks in advance.