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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
acaryasin01
Frequent Visitor

How to calculate average by multiple group as a new column?

Hi guys,

 

I have table, include Page no / % Vlaue / Company name

 

I want a new column which should be calculated by Average of  % Value column which are grouped by company and that company's page no.

 

Desired Column Name is "Avg of % Value" can be seen in the screen shot.

 

any help would be appriciated.

acaryasin01_0-1634216873344.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@acaryasin01 , Create a new columnin dax

=

averagex(filter(Table, [Company] = earlier([Company]) && [pageno] = earlier([pageno]) ) [% Value])

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@acaryasin01 , Create a new columnin dax

=

averagex(filter(Table, [Company] = earlier([Company]) && [pageno] = earlier([pageno]) ) [% Value])

Sorry @amitchandak 

 

I did mistake while applying yor dax formula,

 

Great thanks, It works.

 

Appreciated.

Hi @amitchandak 

 

Thank you for your answer.

 

I applied this dax but it returned only one value to all rows?!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors