Forum Discussion
Tricky - Calculate average of data set
Hi Experts
See attached sample pbix file. The score card shows a average calculate of 0.04 when the expected result is 0.35...
Not sure where the error is..
Net Amt % AVG V2 : =
VAR _tablesummarize =
ADDCOLUMNS (
SUMMARIZE ( 'STD Dev', 'STD Dev'[Date] ),
"@sumbydate", CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
)
RETURN
AVERAGEX ( _tablesummarize, [@sumbydate] )
3 Replies
- Jihwan_Kim
Super User
Net Amt % AVG V2 : =
VAR _tablesummarize =
ADDCOLUMNS (
SUMMARIZE ( 'STD Dev', 'STD Dev'[Date] ),
"@sumbydate", CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
)
RETURN
AVERAGEX ( _tablesummarize, [@sumbydate] )Hi Kim... Could you look at https://community.powerbi.com/t5/Desktop/Standard-Deviation-of-multiple-values-same-dates/m-p/1977638#M748153 - totally stick all day
- Fowmy
Anonymous
Use a measure like this:Avg = AVERAGEX( SUMMARIZE('STD Dev','STD Dev'[Date],'STD Dev'[New Month],"Avg",sum('STD Dev'[Net Amt %])), [Avg] )
