Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to show an average in total. That column has aggregate by SUM. Please see below example (screenshot attached). I have done some research but I am not sure is it really achievable or not. I need some guidance. Thank you.
Solved! Go to Solution.
Hi
Create the measure as below and use it in your visual against the original Sales amount :
The right one is used the new measure
Appreciate your Kudos
Hi
Create the measure as below and use it in your visual against the original Sales amount :
The right one is used the new measure
Appreciate your Kudos
Hi @MahyarTF ,
Is there anything we can do to improve the performance here? Above measures slows down the peroformance in direct query mode. I have 14-15 columns in a table. I really appreciate any guidance here.
Hi @Kandarp ,
Not sure what the solution is ?
I usually use the performance Analyzer to trace and improve the visuals performance.
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |