Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to add a Table Visualization with numerous columns but want to replace the Totals row along the bottom with the Average for each column. Can this be done and if so how?
Thanks
Solved! Go to Solution.
Hi @jamieham
If you want to show average in Total in your Table visual, you can try average function in values.
If your table doesn't have multiple categorys, you can use average directly.
Result:
If your table has multiple categorys, you can add an index and set Don't summarize in index column
Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jamieham
If you want to show average in Total in your Table visual, you can try average function in values.
If your table doesn't have multiple categorys, you can use average directly.
Result:
If your table has multiple categorys, you can add an index and set Don't summarize in index column
Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jamieham , Assume you have one group by (un summarized column) then
averageX(values(Table[row]), [measure])
or
averageX(summarize(Table,Table[row], Table[row2],"_1", [measure]),[_1])
Or use isinscope with measure and Avg Measure
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
if(isinscope(Table[row]) , [measure], [Avg Measure])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |