Sum of Average?

[dk_24]

Hi All,

i want to show the sum of average in card visulization .how do that,please find the below screen shot of requirement.

[Omega]

Check the below link: 

https://community.powerbi.com/t5/Desktop/Calculate-sum-of-averages-by-month-and-item/td-p/59523

OR

You can try creating a new table and applying the below fomula: 

Table = GROUPBY(Table2,Table2[User],"AVG of Users",AVERAGEX(CURRENTGROUP(),Table2[Charts/Hours]))

[dk_24]

Can you please share the link again , you have given the current post link.

[Omega]

Done

[dk_24]

no, i am facing issue with slicer...i have a multiple visuazations on the same page .is there any way to achive this with out createing new table.

thanks.

[v-huizhn-msft · Accepted solution]

Hi @dk_24,

I reproduce your scenario, and get expected result.

Please create three measures using the formula.

Total Charts = SUM(Test[Charts Count])

Avg charts per hour = AVERAGE(Test[Charts/Hour])

sum(Avg charts per hour) = SUMX(SUMMARIZE(Test,Test[User],"Average",AVERAGE(Test[Charts/Hour])),[Average])

Please create a table visual to get the expected table as follows.



Then create a card visual, add the [sum(Avg charts per hour)] measure as follows.



Best Regards,
Angelia

[Anonymous]

Can you please share the PBIX file if possible .

I have a similar kind of requirement.

I would like to create a Measure based on the below SQl Query .

Select sum (time spent)

From (

Select SY_ID, avg( time_spent) time_spent

From   sys_time_table

Where sy_id between 10 and 17

Group by sy_ID

) A11

Sy_ID	time spent
10	51.64936632
11	58.64235554
12	56.39979121
13	60.92594488
14	54.53173522
15	56.47643072
16	50.18421093
17	37.66204409
Output in power bi
	426.4718789

[dk_24]

Thanks for your time Angelia. it's working as expected.