Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
---|---|
97 | |
73 | |
69 | |
43 | |
23 |