Forum Discussion

AnaJakic's avatar
AnaJakic
New Member
8 years ago
Solved

Building sum over multiple rows

Hi everyone,   I am just starting to work with Power BI and I have a question concering the aggregation of a variable.    Here is an tiny excerpt of my ABT that I use for my Power BI visualizatio...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi AnaJakic,

     

    You should be able to use the formula below to create a measure to calculate the sum of revenue in your scenario. :smileyhappy:

    Measure =
SUMX (
    SUMMARIZE ( Table1, Table1[Service], "RevenueAVG", AVERAGE ( Table1[Revenue] ) ),
    [RevenueAVG]
)

    Note: You'll need to replace 'Table1' with your real table name.

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi AnaJakic,

 

You should be able to use the formula below to create a measure to calculate the sum of revenue in your scenario. :smileyhappy:

Measure =
SUMX (
    SUMMARIZE ( Table1, Table1[Service], "RevenueAVG", AVERAGE ( Table1[Revenue] ) ),
    [RevenueAVG]
)

Note: You'll need to replace 'Table1' with your real table name.

 

 

Regards