Forum Discussion

baw556's avatar
baw556
Frequent Visitor
7 years ago
Solved

Summing Column on Multiple Category

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,

 

  • AlB's avatar
    AlB
    7 years ago

    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

3 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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's avatar
      baw556
      Frequent Visitor
      7 years ago

      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's avatar
        baw556
        Frequent Visitor
        7 years ago

         

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

         

        Thanks in advance.