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

[acaryasin01]

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.

[amitchandak · Accepted solution]

@acaryasin01 , Create a new columnin dax

=

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

[acaryasin01]

Sorry @amitchandak 

I did mistake while applying yor dax formula,

Great thanks, It works.

Appreciated.

[acaryasin01]

Hi @amitchandak 

Thank you for your answer.

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