Forum Discussion

PowerBi888's avatar
PowerBi888
Icon for Helper I rankHelper I
7 years ago
Solved

Total Sum of Average data

I have data 6 rows Month      BudgetAmt    SaleAmt       Day 01                   32                 14              1 01                   32                 15              2   02              ...
Need Help
Show and Tell
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi PowerBi888 

    You may create a measure like below:

    Measure =
SUMX ( VALUES ( Table1[Month] ), AVERAGE ( Table1[BudgetAmt] ) )

    Regards,

  • PowerBi888's avatar
    PowerBi888
    7 years ago

    Working fine! using this measure , thanks a lot.

     

    Measure =
    SUMX ( VALUES ( Table1[Month] ), AVERAGE ( Table1[BudgetAmt] ) )

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi PowerBi888 

You may create a measure like below:

Measure =
SUMX ( VALUES ( Table1[Month] ), AVERAGE ( Table1[BudgetAmt] ) )

Regards,

PowerBi888's avatar
PowerBi888
Icon for Helper I rankHelper I
7 years ago

Working fine! using this measure , thanks a lot.

 

Measure =
SUMX ( VALUES ( Table1[Month] ), AVERAGE ( Table1[BudgetAmt] ) )