Solved: Re: Tricky - Calculate average of data set

Anonymous · ‎07-25-2021

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..

https://www.dropbox.com/s/oaoujisc9rxxur0/Average.pbix?dl=0

Jihwan_Kim · ‎07-25-2021

Net Amt % AVG V2 : =
VAR _tablesummarize =
ADDCOLUMNS (
SUMMARIZE ( 'STD Dev', 'STD Dev'[Date] ),
"@sumbydate", CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
)
RETURN
AVERAGEX ( _tablesummarize, [@sumbydate] )

Link to the PBIX file

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

Fowmy · ‎07-25-2021

@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]
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Jihwan_Kim · ‎07-25-2021

Net Amt % AVG V2 : =
VAR _tablesummarize =
ADDCOLUMNS (
SUMMARIZE ( 'STD Dev', 'STD Dev'[Date] ),
"@sumbydate", CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
)
RETURN
AVERAGEX ( _tablesummarize, [@sumbydate] )

Link to the PBIX file

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.