The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am trying to calculate the average from the table of report but it is not working, Request support from the team to calculate an average value of the table
Here is the table of reports taken from five different calculations. I want the average of those five values. in the first row, the average value should be from four values, and in the third row, the average value should come from five.
Hi @Peshal
Are these five column values calculated by measure or calculated column ? Can you provide more data about your case ? Like other calculation formulas, table-to-table relationships, or complete pbix files(remove sensitive info) ?
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |