Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@acaryasin01 , Create a new columnin dax
=
averagex(filter(Table, [Company] = earlier([Company]) && [pageno] = earlier([pageno]) ) [% Value])
@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?!
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |