Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Average for sum of each name by day measure

Dear friends

 

how can i create measure to put in visual by display average of sum of each name by day 

 

ex. data

DateNameAmount
01-01-20John2
01-01-20John3
01-01-20Tim4
02-01-20John5
02-01-20Tim1
02-01-20John2

 

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Is it like this? I'm not sure how you want to handle the date dimension.

v-lionel-msft_0-1607499213903.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

6 REPLIES 6
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Is it like this? I'm not sure how you want to handle the date dimension.

v-lionel-msft_0-1607499213903.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Does it look like this?

v-lionel-msft_0-1606980274897.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

that very close from my expected, but i have to put type of work (didnt show on example) instead date in legend field

Ashish_Mathur
Super User
Super User

Hi,

Show the result that you are expecting.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

to display in cluster visual by x is works for each name and y is average of total amount in each day byname

amitchandak
Super User
Super User

@Anonymous , Try a measure like

 

averageX(summarize(table, Table[Name], Table[Date], "_1", sum(Table[Amount])),[_1])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.