Total Sum of Average data

[PowerBi888]

I have data 6 rows

Month      BudgetAmt    SaleAmt       Day

01                   32                 14              1

01                   32                 15              2  

02                   24                 10              1

02                   24                 15              8  

03                   48                 20              1

03                   48                 19              5  

---------------------------------------------

Sum Data      104                93

I would like to Get Summarize Data in  Column BudgetAmt = 104 

and SaleAmt I can get sum data = 93. But my problem is I can not get result 104 from this data rows.

Thank you for all answer.                

[v-cherch-msft · Accepted solution]

Hi @PowerBi888 

You may create a measure like below:

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

Regards,

[v-cherch-msft · Accepted solution]

Hi @PowerBi888 

You may create a measure like below:

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

Regards,

[PowerBi888 · Accepted solution]

Working fine! using this measure , thanks a lot.

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