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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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